MrExcel Publishing
Your One Stop for Excel Tips & Solutions

combo box linked cell value


Posted by Ania on January 09, 2002 7:00 AM

is there a way to make the linked cell display the value choosen by the user in the combo box?


Posted by Scott on January 09, 2002 7:21 AM

Not sure I understand your question. The "LinkedCell" in the Combo box property should reflect what was chosen. The Combo box will list everything that is in the "ListFillRange".

Posted by Ania on January 09, 2002 8:10 AM

Posted by Ania on January 09, 2002 8:16 AM

Sorry, I wasn't clear.
the combo box displays all the options. after one is picked the linked cell displays a number corresponding to the option that was chosen. i need the linked cell to display the value of the option.
for example assuming the options are

dog
cat
pig

when the "dog" is chosen the box would display "dog" and the linked cell would display 1. i need the linked cell to display dog as well.
is there a way to do it?

Posted by Aladin Akyurek on January 09, 2002 8:33 AM

Ania,

The way you constructed your Combo Box would not be appropriate for that. If you need to use the selected value in some formula (e.g., in a VLOOKUP formula as a lookup value), you can use the INDEX function to access the value selected thru the Combo Box.

First give a name to the range that houses your items via the Name Box on the Formula Bar, eg., List1. Then use:

=INDEX(List1,linked-cell-ref)

Usage in a VLOOKUP formula would be:

=VLOOKUP(INDEX(List1,linked-cell-ref),a-table,....)

Aladin

===============

Posted by Scott on January 09, 2002 8:50 AM

In the ComboBox Properties, go to "BoundColumn". If Dog, Cat ect is in the first column, make sure the value is set to 1. If it's in the second column, change this to 2 etc.

Posted by Ania on January 09, 2002 12:19 PM

Thanks, Aladin!!

Thanks!