Combo box links

W

wuddus

I have a combo box which allows a user to choose from six
items. I want the item selected to appear in a specific
cell, but when I use the "Cell link" function on the combo
box control, it will only insert a number from one to six
in the cell--the number corresponding to the placement on
the list of the item selected in the box.

Help! Is there anyway to get the exact item selected to
appear in the cell the box is linked to? (If it's
important, the possible selections on the list are all
text--no numbers.)

Thanks to everyone in advance!
 
A

Andrew Mackenzie

I am sure there is a better way but you could try creating a lookup table to
return the appropriate text next to the number.
 
D

Dave Peterson

say your linked cell is B1 and your input range is A1:A10.

then you could use a helper cell:
=if(b1=0,"",index(a1:a10,b1))

There's another combobox (on the controltoolbox toolbar) that returns the value
to its linked cell.)

And you may want to look at Data|Validation. The value is in the cell itself.

And for lots of nice notes, visit Debra Dalgleish's site:
http://www.contextures.com/xlDataVal01.html
 
Top