Jump to sheet based on selection from list

This is functionality that already exists in Excel. No need to re-invent the wheel.

Use the sheet navigation buttons that show in each Excel workbook in the lower left hand corner, just above the status bar. Right-click in the area of the arrows for First/previous/next/last sheet and a dialog will pop up showing the sheets of the workbook. Click one to activate it. If the workbook has more than 15 sheets, click "More Sheets" to see more sheets.

RichMelbourne,

See if the following method is what you may need:

Create a menu item for a list of worksheets - Tom Urtis

http://www.atlaspm.com/toms-tutorial...rop-down-list/

Tom’s Tutorials for Excel: Sheet Selector Drop-Down List.
Download example workbook: ComboBox_SheetSelector

Put your sheet names in column A like:

Sheet1
Sheet2
Sheet3

In B1 enter:

=HYPERLINK("#" &A1 & "!A1", A1)

and copy down.

Hi Rich,

npamcpp gave you the build in method but there are other solutions too.
See
http://www.contextures.com/xlToolbar01.html
http://download.cnet.com/Sheet-Navig...-75453633.html
http://www.office-addins.com/-excel-...navigator.html