MrExcel Publishing
Your One Stop for Excel Tips & Solutions

combo box


Posted by Ren on January 18, 2002 1:37 PM

I am attempting to send the contents of 2 combo boxes to two cells. Unfortunately, they are sending the list number rather than the actual value.

How can I do this?

Thanks


Posted by Aladin Akyurek on January 18, 2002 1:40 PM

=INDEX(List,cell-link)

where List is the Input range and cell-link is the cell to which the ComboBox is linked.

Aladin

Posted by Ren on January 18, 2002 1:44 PM

Where do I put this?
what values do I enter for list? cell-link?

Posted by Aladin Akyurek on January 18, 2002 2:03 PM

Ren --

When you set up a ComboBox (via Forms toolbar), you have to fill in an Input range which can be a range like $E$2:$E$10 or a name e.g., ChoiceList that refers to a range plus a Cell link value (say, $A$2), that is, a cell to which you anchor the ComboBox. Now, when you select something from such a ComboBox, the Cell link will report the position of the selected item in the Input range.

If you want to have the selected item in some cell,

=INDEX(ChoiceList,$A$2) or

=INDEX($E$2:$E$10,$A$2)

will return the selected item or use the selected item in a formula like

=VLOOKUP(INDEX(ChoiceList,$A$2),...)

I thought you wanted to return the selected item into some cell provided you constructed the ComboBox as described above, whence my response.

Aladin
===========