Thread: Combo Box vba that works like Forms Menu combo box
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Hector Fernandez Hector Fernandez is offline
external usenet poster
  
Posts: 8
Default Combo Box vba that works like Forms Menu combo box
Squirrel,

I've tried your recommendation, however all it does it put the actual
text from the ComboBox into the chosen linked cell.

So, if my list of options in the ComboBox is, for example:

Car
Boat
Plane

If I choose Boat I would expect it to put a value of 2 in my chosen
linked cell, however it is putting the word Boat in the cell.

What am I doing wrong?

Reply With QuoteReply With Quote