Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is is possible? and how?
I have a comboBox from toolbar. And in it i have list of items through the
ListFillRange. The Combo Box looks as such: Apple- Red Apple-Green Apple-Yellow Watermelon Orange Banana My question is: Is it possible to make a statement where i say something like: [[" If ComboBox.Value="Apple" Then......]] Note that as a Value I have only the word "Apple" and Im not specifying the color. I would like to make VB understand that the if statement applies to all apples even if I dont specify the color like it shows in the combobox. I could make an If statment for each apple but that would be alot of If's. I have over 30 Apples! different colors |