How To Create A Dynamic Worksheet Selection Popup Menu

If you have a workbook with a lot of sheets, then navigating through them can be a pain. This tip is dead simple to implement and will allow the someone to easily navigate to a sheet by using a popup menu. All you need to do is add this small bit of VBA code to your workbook then you can run it by adding and assigning your code to a button.

Download Example File

Sub SheetMenu()
    Application.CommandBars("Workbook tabs").ShowPopup
End Sub

Read this post about How To Use The VBA Code You Find Online to find out how to use this VBA code. When you have this code in your worksheet, you might also want an easy and obvious way for someone to use it like adding a button to run it. You can find out how to do that in this post about How To Add A Form Control Button To Run Your VBA Code.

Now when you press your button, a popup with all the workbook’s sheets listed will display and you will be able to select one of the sheets to navigate to. It’s a small touch that can really enhance usability for workbooks with a lot of sheets.

About the Author

John MacDougall

John is a Microsoft MVP and qualified actuary with over 15 years of experience. He has worked in a variety of industries, including insurance, ad tech, and most recently Power Platform consulting. He is a keen problem solver and has a passion for using technology to make businesses more efficient.