Referring to Textboxes via variables

[NMeeker]

How can I use a variable to perform operations in multiple textboxes or comboboxes on a form?

I have a single form with 60 textboxes, and around 120 comboboxes, I also have a worksheet with 5 different sets of information for each combobox or textbox. (<-- Not sure if that made sense). Basically I have a lot of information and I want to run through my text or combo boxes using variables such as

x = 1....... to imput data into textbox(X) and combobox(X) .... which is read from the worksheet in line (X)

Any ideas? suggestions?
Thanks in advance for any help you can provide..

 

[micro-blades]

I usually keep my controls named "TextBox1" or "ComboBox1" just for this purpose.

For x = 1 to 5
   UserForm1.Controls("TextBox" & x).Value = "your value"
next x

Brian

 

[NMeeker]

Thats great, Now... is there a way to reference all 60 ComboBoxes at the same time... like a combobox change event.... for all 60 comboboxes?