Dropdown list of worksheets

Important Notice

Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • 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.

    [SIZE=2]I should change my name to STUMBED![/SIZE]

  • Re: Dropdown list of worksheets

    Here is some code

    For Each sh In Activeworkbook.Worksheets
    Userform1.lstSheets.Additem sh.Name
    Next sh

    but as Norie says, why bother?



Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!