Steve
Excel already has something similar to what you describe. Look at the
bottom of any sheet and you see the sheet tabs. Look to the left of the
left-most sheet tab. You see 4 left/right arrows with which you can scroll
the sheet names. Right click inside that group of arrows. This displays
all the sheet names. Click on one and that sheet will become the active
sheet. If you have more sheets that the list can show, the last item in the
list will be "More sheets". Click on that and you will see all the sheets
names. HTH Otto
"Steve" wrote in message
...
I need a macro or such like to aid worksheet selection, I intend on using a
dropdown list box or combo box with 12 or more sheets available on it.I'd
like to be able to selct the worksheet needed from the control and then it
goes to that worksheet.