Search results for query: *

I have an excel sheet with a list of dates and I want to find the matching row for a date in another sheet. The list of dates are formatted as dates, not as text... Example: In sheet1 I have a text value in cell A2 like "2022-08-29 09.58.51" A formula in cell B1...

How do I write the range ActiveSheet.Range(A5:B5,D5:AM5) using the cells notation ? I want to define the range using row numbers and column numbers...

How can I format values to always display as xxxx E-10 So not just a scientific notation but specific E-10

How can I display all values in a excel sheet as xxxE-10 Not just scientific notation but specific as E-10

I have a 3th party COM addin which gives a split button in the "message" toolbar in Outlook. Now I want to execute the upper-button using vba, is that possible ? I can not add the addin to the reference of the vba project !

After the update from last week several buttons don't show up anymore in a personal Excel toolbar created in the CustomUIEditor. This is the part of the working code before the update: <group id="grpFavorites"label="---OFFICE TOOLS ---"> <button idMso="FileSave"size="large"/> <separator...

Im setting up a website using wordpress and I want to create a "digital PObox" to put result files in for specific members. So the logged user can only access that file and no-one else. Is there a good plugin I can use to achieve this option ? I'm not a experienced user ;-)

I have a combobox populated with an array declared as variant. A part of the array looks like: 156727 C. v. Staveren 158552 B. Stevense 194042 P. Strijbos 169968 E. Strucks 40406 C. Swens F195909 A. Ticheloven The combobox is set to show the first column Typing F the...

I get an error using the code below.... DbaseArray = ThisWorkbook.Sheets("test").Range("A1:K100") leaving out the first part ThisWorkbook.Sheets("test"). the code is correct ??!! But I need to point to that specific sheet... Am I missing something ? The Sheet "test" does exist !

I want to store cells, matching some criteria, in an array and loop through these cells to show the results. I already have a code to select the cells and can store the data in a 2 dimensional array. The stored cells are in different sheets also... What do I have to store in the array for later...

I've created a custom ribbon tab in an excel-addin (xlam) displaying various groups depending on the name of the active document using getVisible in group definition. Example: <group id="grpSearch" label="--- SEARCH ---" tag="GeneralgrpSearch" getVisible="ShowFlintGroup"> This works fine on all...

I've created a custom tab with links to macro's in an excel workbook using Custom UI editor. Everything works well and the custom tab is shown correctly. Now I want to add a button but the Custom UI Editor gives an error "file contains corrupted data" and the file is closed without showing the...

Is it possible to create a link matching only the first record of the right table in a one to more relation More in detail.... Linking the tables below I get 4 lines selecting "side A" but I only want to get one line showing the first persons name and location, not all ! Table 1 side A...

Is it possible to create a custom tab in excel containig a checkbox showing de protection state. Checkbox checked if worksheet is protected and unchecked when worksheet is not protected. I was thinking of a worksheet_activate procedure but how do I control the checkbox in the ribbon using vba ?

I'm using the code below inside a WORD macro. When I try to run another macro opening another filetype the selection is restricted to the xls-files defined in the previous macro How do I reset the filters of the msoFileDialogFilePicker at the end of the macro ? Dim fd As FileDialog ' select...

I want to insert a column at the right of the column with variable LR but the code below inserts a column to the left of LR...? Why doesn't this code work like I thought ? ActiveSheet.Columns(LR).Insert Shift:=xlToLeft

Who can help me solving the error in the code below... Sub Start_Excel_Proces() 'Declare file dialog, Excel workbook and application objects Dim fd As FileDialog Dim newsheet As Boolean Dim xlApp As Excel.Application Dim xlWB As Excel.Workbook Dim xlWS As Excel.Worksheet 'Declare the used...

I'm creating a WORD macro to read data from an excel workbook for using in a userform. The excel sheet needs to stay open. When I open the userform after the excel application, the form is opened behind the excel application and is not visible. How do I open the userform in front of all windows ?

Running the macro below for the first time there is no problem but running the macro the second time I get an error "Method 'Rows' Of Object '_Global' Failed" in the function "lastrow" ... Can anyone explain why this happens the second time ? Sub test() read_NCdata "4022.635.94672" End Sub...

Is it possible to show the date in the cells in the format (weeknr) jjjj-mm-dd bij formatting the cells? With other words can I show the dates in the cells like (01) 2016-01-01 and (05) 2016-02-01 instead of just 2016-01-01 and 2016-02-01 ?