Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update numerous comboxes at once
Hi,
I can update the rowsource of an individual combobox programatically using the below; ComboBox2.RowSource = "details!g4:g24" however i need to do a lot at a time, looping through them one by one. I had hoped I could use something similar to the below; Dim cmbo For i = 4 To 34 cmbo = ComboBox & i cmbo.RowSource = "details!c4:c24" next i etc however this errors on the cmbo.RowSource part I have tried changing the line to; "ComboBox & i".RowSource and this errors. I have also tried changing ComboBox & i to "ComboBox" & i however this does not work either. Any suggestions for where i'm going wrong? My comboboxes are named ComboBox4 through to ComboBox34 Thanks, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hiding Rows and buttons/comboxes, over the rows | Excel Programming | |||
How do you add numerous subtotals in a spreadsheet? | Excel Worksheet Functions | |||
Macro to make all checkboxes false and clear all comboxes | Excel Discussion (Misc queries) | |||
Comboxes | Excel Programming | |||
Need to sum up numerous columns in different worksheet into 1 | New Users to Excel |