Calling second userform from main form.

[JudyHNM]

I have an Excel 2016 spreadsheet and want to be able to run multiple reports from it. I have created a userform to run one of the reports. I have a command button on my spreadsheet to bring up the userform. This is working fine. I want to add a Main Menu type of userform that is brought up with a command button. That userform would have a series of Command Buttons that bring up other userforms that collect parameters and run various reports. How do I manage calling one userform from another?

Thanks, Judy

 

[Legacy 396030]

Perhaps a 'Switchboard' as the first worksheet to put the buttons?

 

[JudyHNM]

How do I set up a Switchboard in Excel?

 

[Legacy 396030]

The worksheet is called that it is just how I have set up my workbooks. On that sheet I put instructions and buttons for protecting and unprotecting sheets, launching reports or whatever you wish. Just create the macros in vba and insert a shape (I like rounded rectangles). Name the shape then assign the macro to it.

From the other worksheets you can insert the rounded rectangle for bringing you back to the 'Switchboard'

It is up to you to design how you wish. This is why I like doing it this way.

Good luck with your project!

 

[JudyHNM]

Thanks -- I never thought of that approach. I was trying to use all userforms to emulate the Switchboard in Access. I will give your suggestion a shot.