FrenchCelt
Board Regular
- Joined
- May 22, 2018
- Messages
- 214
- Office Version
- 365
- Platform
- Windows
Hello,
I'd like to code a macro that essentially causes a dialog box to pop up with a few options to select from, each selection calling a different macro already stored, as a way to consolidate the use of several similar macros under one shortcut key command instead of having to remember all the different shortcut keys for each variation.
Does anyone have any coding suggestions? For example, for the one I want to start with, I have two macros to select from. I'd like the dialog box to ask the user to select from either:
10A/10B Reports
or
12A/12B Reports.
If 10A/10B is selected, then the macro should Call 10A/10B Report.
If 12A/12B is selected, the the macro should Call 12A/12B Report.
I'd like to code a macro that essentially causes a dialog box to pop up with a few options to select from, each selection calling a different macro already stored, as a way to consolidate the use of several similar macros under one shortcut key command instead of having to remember all the different shortcut keys for each variation.
Does anyone have any coding suggestions? For example, for the one I want to start with, I have two macros to select from. I'd like the dialog box to ask the user to select from either:
10A/10B Reports
or
12A/12B Reports.
If 10A/10B is selected, then the macro should Call 10A/10B Report.
If 12A/12B is selected, the the macro should Call 12A/12B Report.