View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nigel Nigel is offline
external usenet poster
 
Posts: 923
Default 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