Combo-List Box

  • Thread starter Thread starter A
  • Start date Start date
A

A

I've almost got this to work, (with limited excel
experience), but the numeric value of the item chosen
appears in the designated cell, instead of the item
chosen. Is there an easy to fix this.

thanks!
 
That's how it works. Use that cell in something a VLOOKUP table to return
the actual value.
One way, if your list that the combo box is set to were in C1: C50, in
B1:B50 make B1 > 1, B2 >2 etc down to B50, in another cell
=VLOOKUP(designated cell,B1:C50,2,FALSE)
Regards,
 
Back
Top