MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Box will popup and you can run macro from it?


Posted by Hans on April 05, 2001 9:33 AM

I'm lookingfor a box to appear so I can
can select and run a macro? Hopefully it will
be combo boxes so I can run a few macros
simulataneously..Is is possible? Thanks


Posted by Azli on April 05, 2001 12:45 PM

You can create another macro to run other macros, here's the code to run anothe macro named "MACRO_NAME" from another macro.

Application.Run "MACRO_NAME"

Be sure to put the macros in the order you want them to run.
You can then assign the macro that runs other macros to a control button. Be sure you have the FORMS toolbar showing so that you can choose the button control to insert into your worksheet.

Posted by Dave Hawley on April 05, 2001 2:26 PM

Azli, regarding a "box to pop up" Push Alt+F8, this will give you the standard Run Macro Dialog box.

Dave


OzGrid Business Applications