Forms - Combo box

[Manos]

Dear all,

when i create a combo box in excel and select as a range
a list in the cell reference i can see a figure, probably
the number of the item i selected from the list

There is any possibility in the cell reference to see the
text i have selected from the range?

Thanks in advance
Manos

 

[DDM]

Manos, the combo box returns a number that corresponds to the position of
the item you selected in the list. So if you select the first item in the
list, the combo box returns 1. If you want to display the actual text
somewhere, use the INDEX function:

=INDEX(ComboBoxInputRange,ComboBoxOutputCell)

 

[Dave Peterson]

and if the dropdown is empty, you can:

=if(comboboxoutputcell=0,"",INDEX(ComboBoxInputRange,ComboBoxOutputCell))

(just in case)