Thanks Nigel but I get a Message stating sub or function undefined for
Controls. Do I have to define Controls and/or is this a macro for a
userform. If I have to define Controls could you let me know how. The
combobox's that I am using are on a sheet. Sometimes I have to import values
from another workbook. The problem I am having is when the values come into
the sheet and hit the combobox's the macro attached to the boxes goes off
shutting excel down because of overload. That is why I need to hit the
combobox's with the values instead. If I input the value into the box
everything is good. I have 175 boxes to input. Hence the need for a macro
that will loop through the boxes. I could write out each in vba I am just
trying to save myself hours of typing.
--
Thanks!
Shane W
Nigel said:
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