after you place the combobox on the worksheet, right click on it and select
view code.

You should be in the click event.

Put the code you want to run there.
--
Regards,
Tom Ogilvy

Nazeer wrote in message
...
Thanks, Tom. How do I use the click event. Can you provide
specific details. I am not familiar with events.

thanks.


-----Original Message-----
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.


.