Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Invoking a macro from within another
Can't figure this out.
I want a macro to run another macro or several other macros. How do you do it? Thanks...I know this should be simple, but I can't find the solution anywhere. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Invoking a macro from within another
Sub RunMacro
MyTest MyOutput end sub sub MyTest msgbox "this is my test" end sub sub MyOutput msgbox "this is my output" end sub in other words, just put the name of the sub and it will run. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Invoking a macro from within another
Hi It is literally as simple as: Sub MyMacro() MyOtherMacro End Sub Sub MyOtherMacro() Msgbox "Hello, World!" End Sub You don't need to use the Call statement. Hope this helps! Richard -- RichardSchollar ------------------------------------------------------------------------ RichardSchollar's Profile: http://www.excelforum.com/member.php...o&userid=34698 View this thread: http://www.excelforum.com/showthread...hreadid=546683 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Invoking a macro from within another
Thanks - that was easy.
"jnsaunders" wrote in message ... Can't figure this out. I want a macro to run another macro or several other macros. How do you do it? Thanks...I know this should be simple, but I can't find the solution anywhere. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Invoking macro to insert rows according to DDE imported data | New Users to Excel | |||
Invoking macro when a tab is selected | Excel Programming | |||
Switching woorkbooks & and invoking a macro from within a macro | Excel Programming | |||
Excel Macro Code invoking InputBox. | Excel Programming |