Hi Bob
Sorry to be a pain

What exactly do you mean "MATCH it against the combobox source and click
event"?


"Bob Phillips" wrote:

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" wrote in message
...
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?