You have to MATCH it against the combobox source data in then click event.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"John Data" <[email protected]> wrote in message
news:[email protected]...
> If I link a cell in a combo box in the Forms module and look up the first
> item in a range, the linked cell fills in with number 1. If I select the
> secong item in the range, number 2 is filled in the linked cell and so on.
> How can I get the same result by using the combo box in the control
toolbox
> menu as it fills in the linked cell with the actual data from the lookup
> range rather than numbers 1, 2 etc?
Bookmarks