I was wondering if there is a way to populate a dropdown list of a userform with the worksheet names.
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?
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!