Drop Down Lists

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DJB - 22 May 2008 14:17 GMT

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

Reply to this Message

Stefi - 22 May 2008 14:56 GMT

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?

Reply to this Message

Reitanos - 22 May 2008 15:24 GMT

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.

> 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!
[quoted text clipped - 12 lines]
>
> > Is it possible to create a drop down list that shows the sheets in a workbook?

Reply to this Message