ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Using forms to navigate (https://www.excelbanter.com/excel-discussion-misc-queries/171507-using-forms-navigate.html)

mdavisfl

Using forms to navigate
 
I have multiple Workbooks with multiple Worksheets and Charts in each. Right
now I have a central worksheet with a bunch of Command Buttons with Macros
that navigate around these sheets and charts.

I want to develop a Form (?) to navigate to Workbook1Sheet1,
Workbook2Chart3, etc. For example, choose Workbook 1, then get the
sheet/chart choices within that Workbook. I would like to return to this
central location when the requested sheet/chart is closed.

What is the best way to develop a form that navigates like this and also
allows you to return to the central location?

Thank you for your help.


All times are GMT +1. The time now is 02:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com