Create a Drop down List on a Form

[Al]

I have an excel (2003) document which has quite a number of sheets. I would
like to create a form (msg box) which lists all the sheet names (via a drop
down box) for the user to select which sheet they want to view, then open the
sheet when they click on the sheet name. Help please?

 

[Otto Moehrbach]

Al
Are the sheets hidden? If they are hidden, you will need VBA to unhide
and select the applicable sheet. If the sheets are not hidden, try this:
Right-click within the sheet navigation arrows located in the left lower
corner of the screen. This will display a list of the sheets in the
workbook. Click on one and it will become the active sheet. If the
displayed list does not include all the sheets, the last item in the list
will be "More sheets". Click on that and you will get a scrollable list of
all the sheets. Post back if you need more. HTH Otto

 

[Gord Dibben]

I like Bob Phillips' browsesheets macro.

http://tinyurl.com/yoa3dw


Gord Dibben MS Excel MVP