| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Public Variables and Combo Box Usage | Excel Discussion (Misc queries) | |||
| File Search for Combo Box Usage - Excel 2007 | Excel Programming | |||
| Wildcard Usage: I absolutely need this to count?/sum? two or more criteri | Excel Discussion (Misc queries) | |||
| Memory Usage In Excel VBA Programming | Excel Programming | |||
| combo Box programming | Excel Programming | |||
Linear Mode
