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.

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


Subscribe for awesome Microsoft Excel videos 😃

Related Posts



Get the Latest Microsoft Excel Tips

Follow Us

Follow us to stay up to date with the latest in Microsoft Excel!

Subscribe for awesome Microsoft Excel videos 😃