If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
decision on Combobox
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 |
#3
|
|||
|
|||
decision on Combobox
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 . |
#4
|
|||
|
|||
decision on Combobox
-----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. |
#5
|
|||
|
|||
decision on Combobox
-----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 |
Thread Tools | |
Display Modes | |
|
|