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:

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

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.

On May 22, 9:56 am, Stefi wrote:
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:

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