Using combo box
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.
--
Regards,
Tom Ogilvy
"Jessie" wrote in message
...
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
|