Tezzies
07-22-2008, 01:25 AM
Hello all,
I have several ComboBoxs to populate and would like to try and do this using some sort of loop. Is this possible??
My code is similar to this-
Dim i as integer
Dim Temp as msforms.combobox
For i = 12 to 30
set Temp = "CbxComments" & i
Temp.additem "test1"
Temp.additem "test2"
next i
I know i could popualte the boxs seperatly but in practice I have lots of boxs to populate and would like to be box clever.
I have several ComboBoxs to populate and would like to try and do this using some sort of loop. Is this possible??
My code is similar to this-
Dim i as integer
Dim Temp as msforms.combobox
For i = 12 to 30
set Temp = "CbxComments" & i
Temp.additem "test1"
Temp.additem "test2"
next i
I know i could popualte the boxs seperatly but in practice I have lots of boxs to populate and would like to be box clever.