Code for Jumping to a sheet needed

**charles.2345** · 05-21-2011, 08:57 AM

Hi all,

I want the code for a macro to go to the sheet whose name I can type in the pop-up. I want to be able to give the first or last few characters instead of the full name. In any case it should go to the closest match. Thanks in advance.

-Charles.

**JBeaucaire** · 05-21-2011, 10:48 AM

This will do that:

Please Login or Register  to view this content.

**Marcol** · 05-21-2011, 01:02 PM

Another way, using a UserForm with a ComboBox and CommandButton
In the UserForm Module

Please Login or Register  to view this content.

Then in a standard module

Please Login or Register  to view this content.

The combobox will populate with all the Sheet names, including Chart sheets in tab order.

The code can be easily modified to list only Worksheets, or Charts

Run the macro "SheetNavigator"

Hope this helps

**charles.2345** · 05-24-2011, 12:43 AM

Hi Jerry,

This works like a charm.

Thanks

Charles

**JBeaucaire** · 05-24-2011, 12:59 AM

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

**charles.2345** · 05-24-2011, 01:04 AM

Originally Posted by Marcol

Another way, using a UserForm with a ComboBox and CommandButton
In the UserForm Module

Please Login or Register  to view this content.

Then in a standard module

Please Login or Register  to view this content.

The combobox will populate with all the Sheet names, including Chart sheets in tab order.

The code can be easily modified to list only Worksheets, or Charts

Run the macro "SheetNavigator"

Hope this helps

Your code also worked soooo fine. Love it. Thanks.