You want to use the Click event if it is an ActiveX combobox from the
control toolbox toolbar.
in design mode (if on a worksheet) or in the VBE, double click on it to get
to the click event.
If from the forms toolbar, right click on it and select assign a macro
If produced by the List Option in data validation, then if xl2000 or later,
use the Change event.
See Chip Pearson's page on Events
http://www.cpearson.com/excel/events.htm
--
Regards,
Tom Ogilvy
"James" wrote in message
...
I am trying to get a macro/function to execute once a selection is made in
the combobox. So far I have had no luck finding out how to do this.