Text String Loop Question

[rwr]

Hello.

I was wondering if there is a way to use a text string for a ComboBox name in an if statement. Say I have 10 ComboBoxes in a UserForm named combobox1 combobox2, etc., and I wanted to set up a loop with 10 iterations. Is there a way to do something like:

For j = 1 to 10
If "userform1.combobox" & j = "100" Then
...
End If
Next j

I tried this but it didn't work. Is this a dumb way of trying to do this? Any ideas?

Thank you so much.

[StephenR]

Here is one approach which will run through all the controls - assign to a button perhaps.

Please Login or Register  to view this content.