If you are using a combobox from the control toolbox toolbar, then use the
click event.

--
Regards,
Tom Ogilvy

"Nazeer" wrote in message
...
I have a macro that I want to run everytime a user select
an option from a drop down list. What the macro does is,
it takes the user to a specific cell depending upon their
selection.
Currently, the macro can only be run either manually or by
clicking on a toolbar button. But I want the macro to
automatically run as soon as the user makes a selection.

Any ideas?

Thanks.