View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default How do I get A ComboBox to execute

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.