Code to take me directly to a specified worksheet??

[monkey2003]

Hello all..

Im not sure if this is possible.. but i have many worksheets, lets say 50. and i don't want to scroll across every one to get to the worksheet i want. I was wondering if there is any way i can list all 50 worksheet names in a dropdown list, and when i select the worksheet name i want from the list, it takes me directly to that worksheet. Is this possible?? if so pleasssssse give me the code.. thank you sooo much..

[VBA Noob]

See link

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

VBA Noob

[monkey2003]

See link

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

VBA Noob

You are AWESOME.. Thank you very much