Run a macro

[gregor_davies]

I have developed a macro that will take a user to a particular point in the workbook depending on what option they select from a drop down box.

How can I get this macro to run automatically once the user has selected their option?

[jose luis]

Hi,

if i undersootd your question, you could assign the macro to be option button the user selected. In order to do that you have to right select the option button and assign it the macro just written.

Hope this helps

Jose Luis

[gregor_davies]

Probably wasn't to clear in my explaination, the user selects the option from a drop down list.