Drop Down Lists

  • Thread starter Thread starter DJB
  • Start date Start date
D

DJB

Is it possible to create a drop down list that shows the sheets in a workbook?
 
First create a list in a helper column (e.g. N) with this macro, then use the
N1:N? range as source of validation list!

Sub shlist()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
Range("N" & ws.Index).Value = ws.Name 'change N as you like
Next ws
End Sub

Regards,
Stefi

„DJB†ezt írta:
 
Or, if you're lazy like me you can right-click on one of the "VCR"
buttons in the bottom left corner (you know, the four browsing buttons
used to navigate the sheets) if your list isn't too long.
 
You must log in or register to reply here.

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

Dependent drop down dynamic range formula, off sheet. 7
Formatted cell column in drop down list 1
Drop Down with dynamic named range offsheet source list 14
Displaying drop down list arrows 2
Link Drop Down with Pivot Table 2
Starting drop down lists at the top 1
Drop Down Lists 2007 10
DROP DOWN ARROW NOT APPEARING ON ANOTHER USERS EXCEL SHEET WHEN SETUP IN ORIGINATORS SHEET 6

Back
Top