Search results for query: *

Hi, I am putting together an application which is controlled via a userform. Part of the code has opened another workbook. There is a command button on the userform which needs to activate and show this workbook without closing the userform (this has values in list boxes and other controls). Is...

Hi, I need to populate the columns of a multicolumn listbox on a userform in Excel. I have read data from a text file and have ended up with an array of the values I wish to write to the listbox. A simple example:- array = "one","two","three","four" I do not know in advance how many rows...

I have written some VBA code that requires some input from a userform. This code will dynamically control a Chart in Excel. When the Chart is selected and code to display the userform is run the following error occurs:- Run-time error '1004' Method 'Range' of '_Global'failed The code to...

Hi, I am trying to dynamically change a list in a combobox control on a custom commandbar based on the selection made in another custom combobox on the same commandbar. Is there anyway of clearing the entries in the second combobox and then adding entries to this combobox based on the selection...