Drop Down Lists

[DJB]

Is it possible to create a drop down list that shows the sheets in a workbook?

 

[Stefi]

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:

 

[Reitanos]

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.