Create a Drop down List on a Form

A

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?
 
O

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create List for ComboBoxes 4
Insert new row with drop-down box but problem with cell linkreferring to the original drop-down box 2
How to hide password? 1
Copy adjacent Sheet and name from a list 42
drop down problem 3
EXCEL DROP DOWN 2
Data Validation List problem 5
Run or Call a sub from the list of subs in a drop down. 8

Top