I have many cbox value to chg would like to use integer to do
Use the Controls function on the form, the following illustrates identifying
each control called ComboBox1 to ComboBox3
Dim xControl As Integer
For xControl = 1 To 3
Controls("ComboBox" & xControl).Enabled = False
Next
--
Cheers
Nigel
"whylite" wrote in message
...
I have many combobox's and would like to change there values. Rather than
listing everysingle one in vba I would like to use a interger and have it
cycle through all of the combobox's and update them with a list. Any
idea's
how I can write the code.
--
Thanks!
Shane W
|