decision on Combobox

[Tony]

Hi,

I created a combobox based on a cell range F1:F4. This
works fine. The problem I'm having is how can I make a
decision on the combobox selection in another cell? Do I
need to write VBA code to do this? (I hope not but, If I
have to)

I've tried using an IF statement in the cell that is
evaluating the combobox but its not working. I referenced
the name of the combobox but, how do I evaluate the
selection?

Thanks in advance for your help!
Tony

 

[Frank Kabel]

Hi
do you use a combobox or a listbox created by 'Data - Validation -
List'

 

[Janet]

If you are using a ComboBox and not Validation, then link
set the link cell in Properties and base the evaluation on
that.

Janet

 

[Guest]

-----Original Message-----
Hi
do you use a combobox or a listbox created by 'Data - Validation -
List'

Thank you Frank, I was using a form control. The
validation list gives me exactly what I need. It works
great.

 

[Guest]

-----Original Message-----
If you are using a ComboBox and not Validation, then link
set the link cell in Properties and base the evaluation on
that.

Janet

Janet,

Could you elaborate on that. Originally I was using a
ComboBox and not validation. I don't understand what you
mean by link set. Appreciate your input.

Tony