Combo box with a loop on a form

[Fire_Chief]

I have a form that has 64 combo boxes on it. I want to fine if any of them have the letters "TBA" in them.

I want the loop to stop at the first one it finds.

I have tried MANY for next loops and nothing works.

Writing out combobox1, combobox2, ect. in an If, else statement works but it's to long and I want to learn how to do it more efficiently.

Thank You

Marty

 

[Norie]

If the comboboxes are named ComboBox1, ComboBox2 etc try this.

For I = 1 To 64
    If Me.Controls("ComboBox" & I).Value = "TBA" Then
        MsgBox "ComboBox" & I & " is TBA."
        Exit For
    End If
Next I

 

[Fire_Chief]

Thank You so much. It works fine.
If it's not to much can you explain why you use Me.Controls before ComboBox

Thank you again

 

[Norie]

Me is a reference to the userform the controls are on, Controls is a property of the userform and it returns a collection of all the controls on the userform.

 

[Fire_Chief]

Thank You. I think I get it...