Navigating between worksheets using a drop down menu

[ncdogteam]

I have been searching the forums but I don't seem to hit the correct
search criterias, please help


I need to create a drop down menu on one of my worksheets. The list
should contain all the woksheet/tabs in the workbook and allow me to
navigate to any sheet. When a new sheet is added it should also be
added to the drop down menu

 

[VBA Noob]

Hi,

The attached link might get you started

http://www.contextures.com/xlToolbar01.html

VBA Noob

 

[Die_Another_Day]

I have written my own code to do this and I will email it to you if you
would like, however, if you right click the arrows that let you
navigate the next/previous sheet it pops up a menu that lets you select
the sheet you wish to go to.

HTH

Die_Another_Day

 

[Ragdyer]

XL has a built-in sheet list that is accessible by simply right clicking in
the small directional arrows to the left of the sheet tabs.
This gives you a list of the first 15 sheets, with an option to expand the
list to an infinitely scrolling list of *all* the sheets.

Click on a name, and the sheet is immediately selected.

 

[Dave Peterson]

Maybe you can use or adapt this (which uses a toolbar):

http://www.contextures.com/xlToolbar01.html
from Debra Dalgleish's site.