Using combo box

[Jessie]

Hello,
is there a way to use the values in the combo box instead
of the index?

for example:
In the combobox the first selection is 7.5. Whne the user
selects 7.5 the cell that the combobox links to is
populated with a 1. How can I make it populated with 7.5?

thanks,
jessie

 

[Tom Ogilvy]

You can't with a forms combobox/dropdown (without programming). What you
can do is link to the cell underneath the combobox. This cell will then
hold the value. Now in the visible cell, put in a formula like
=index(linked_range,index number, 1)

To pull the appropriate value from the source data.