Wildcard Usage in Combo Box Programming
 

I have a combo box that has groups of similar options - for example:

Option1 (Term1)
Option1 (Term2)
Option2 (Term1)
Option2 (Term2)

etc.

I need the same event to occur by group - that is, whether it is Option1
(Term1) or Option1 (Term2) I would like the same event to occur.

How can I refer to the choices in the combo box in an IF statement without
using OR multiple times? Is there a way to use a wildcard?

If ComboBox1.Value = "Option1 (Term1)" or "Option1 (Term2)" or ... or ... or

Thanks.

Wildcard Usage in Combo Box Programming
 

If Left(ComboBox1.Value, 7) = "Option1" Then
...
End If


"BJ" wrote:

I have a combo box that has groups of similar options - for example:

Option1 (Term1)
Option1 (Term2)
Option2 (Term1)
Option2 (Term2)

etc.

I need the same event to occur by group - that is, whether it is Option1
(Term1) or Option1 (Term2) I would like the same event to occur.

How can I refer to the choices in the combo box in an IF statement without
using OR multiple times? Is there a way to use a wildcard?

If ComboBox1.Value = "Option1 (Term1)" or "Option1 (Term2)" or ... or ... or

Thanks.