Listbox to open worksheet

**nickmax1** · 10-29-2012, 10:16 AM

I have a userform that opens up a listbox for all my worksheets. It then allows the user to select what worksheet to go to, and upon clicking the GO button on the form the macro takes the user there (and runs another macro)

How do I bypass the section whereby the user has to hit a button? I just want the user to select the worksheet from the listbox and it goes to the worksheet automatically....

Please Login or Register  to view this content.

**Mike_e** · 10-29-2012, 11:08 AM

Why not just put the code to navigate to the selected sheet in the listbox's change event..

Please Login or Register  to view this content.

**nickmax1** · 10-29-2012, 11:11 AM

Not sure what that means i am afraid!!

Basically all I want to do is "activate" a sheet selected by the user as it runs my MonthlyProductionEmail macro.