How To Create A Dynamic Worksheet Selection Popup Menu

2017-01-23

VBA

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 freelance consultant and trainer specializing in Excel, Power BI, Power Automate, Power Apps and SharePoint. You can find other interesting articles from John on his blog or YouTube channel.

Subscribe

Advertisement

Related Articles

Comments

0 Comments

Get The Latest News

Follow Us

Follow us on social media to stay up to date with the latest tips in Excel!

Pin It on Pinterest

Share This