Search results for query: *

Your right, what a dummy I am! Thanks, you've saved me a lot of time as I thought I would have to create another userform and write the spreadsheet values to that. Sometimes you can't see the wood for the trees! Regards

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...

Thanks I'll give it a go and let you know Thanks

I cant do that as the array will be N rows by 4 columns. I dont know how many rows I need and you can't seem to redimension a dynamic array (possibly a new post?). If I use a custom type, and build an array of this type holding the values which can be redimensioned, I can not use this array with...

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, Try this code Sub insert_blanks() Dim intR As Integer, MyValue As String 'select range containing first entry in your example range B2 Do Until ActiveCell.Value = "" MyValue = ActiveCell.Value Do Until ActiveCell.Value <> MyValue ActiveCell.Offset(1...

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...