decision on Combobox

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

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

--
Regards
Frank Kabel
Frankfurt, Germany


Tony wrote:
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

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

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

--
Regards
Frank Kabel
Frankfurt, Germany


Tony wrote:
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

.

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

--
Regards
Frank Kabel
Frankfurt, Germany


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

-----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