Using one macro to run another

excelmacro · Apr 25th, 2002, 01:31 PM

I know this has been mentioned other times, but I can't find it by searching. What VB code do I put in to run one macro with another macro?

NateO · Apr 25th, 2002, 01:39 PM

One of three ways:

To run myMcr

put one of the following lines of code in your macro

myMcr

call myMcr

application.run("myMcr")

Hope this helps.

_________________
Cheers, NateO
"Me no are no nice guy."

[ This Message was edited by: NateO on 2002-04-25 12:39 ]

excelmacro · Apr 25th, 2002, 02:13 PM

I am trying to run a macro in a module from a form macro, but the form macro says it can't find the module macro. any reason why? Do I have to put all my macros into the form?

NateO · Apr 25th, 2002, 05:23 PM

You should be able to run it with:

Code:

Application.Run ("myMcr")

Double check the spelling [of your macro] perhaps. If not respond accordingly we can add the module name, etc...

_________________
Cheers, NateO

[ This Message was edited by: NateO on 2002-04-25 16:25 ]

excelmacro · Apr 26th, 2002, 07:58 AM

Application.Run ("Cancel_Click")
-the macro associated with this item says it can't find the macro Cancel_Click (runt time error 1004)

Private Sub Cancel_Click()
End
End Sub
-here is the macro cancel click

Apr 25th, 2002, 05:23 PM	#4
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	You should be able to run it with: Code: Application.Run ("myMcr") Double check the spelling [of your macro] perhaps. If not respond accordingly we can add the module name, etc... _________________ Cheers, NateO [ This Message was edited by: NateO on 2002-04-25 16:25 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 25th, 2002, 01:31 PM	#1
excelmacro Board Regular Join Date: Apr 2002 Location: Alberta, Canada Posts: 50	I know this has been mentioned other times, but I can't find it by searching. What VB code do I put in to run one macro with another macro?

Apr 25th, 2002, 01:39 PM	#2
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	One of three ways: To run myMcr put one of the following lines of code in your macro myMcr call myMcr application.run("myMcr") Hope this helps. _________________ Cheers, NateO "Me no are no nice guy." [ This Message was edited by: NateO on 2002-04-25 12:39 ]

Apr 25th, 2002, 02:13 PM	#3
excelmacro Board Regular Join Date: Apr 2002 Location: Alberta, Canada Posts: 50	I am trying to run a macro in a module from a form macro, but the form macro says it can't find the module macro. any reason why? Do I have to put all my macros into the form?

Apr 26th, 2002, 07:58 AM	#5
excelmacro Board Regular Join Date: Apr 2002 Location: Alberta, Canada Posts: 50	Application.Run ("Cancel_Click") -the macro associated with this item says it can't find the macro Cancel_Click (runt time error 1004) Private Sub Cancel_Click() End End Sub -here is the macro cancel click