Board index » Excel » How do I get A ComboBox to execute

Excel14
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.


-

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" <James@discussions.microsoft.com>wrote in message



-