Drop Down Lists

  • Thread starter Thread starter DJB
  • Start date Start date
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.
 
Back
Top