Dropdown list of worksheets

Re: Dropdown list of worksheets

It's definitely possible and I'm sure if you did a search on the board (or follow the links above your post) you'll find threads dealing with this.

But why do you want to do this? If it's to help navigate a workbook then why not just right click on the navigation arrows in the bottom left of the workbook. No need to reinvent the wheel.:)

Re: Dropdown list of worksheets

So here is what you can do. (Have never done it)

Write or pull the sheets name to a cell.
Save the names as a range.
Use dropdown set to the named range.

You could even use a validation dropdown.

Re: Dropdown list of worksheets

Here is some code

[vba]
For Each sh In Activeworkbook.Worksheets
Userform1.lstSheets.Additem sh.Name
Next sh
[/vba]

but as Norie says, why bother?