Result from a combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a speadsheet with a combobox in it and 4 items.

When I select an item from the list, I want the value to be displayed in
another cell...all I seem to get is the index of the item selected (e.g.1st
item selected, 1 is diplayed in the result cell).

Is there anyway to get the actual data to display in another cell when an
item is selected?

Thx
 
Use INDEX function to get the value from combobox list depending on the
selected index number.
 
Back
Top