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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo box, select item, auto create another combo box in field 2
Strange problem in Excel combo box 4
Combo Boxes 1
non-repeating Comboboxes values 9
combo box 2
combo box 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Combo box: Viewable Title 1

Back
Top