Run macro from name stored in variable?

[chubster264]

can you run a macro using its name stored in a variable?

e.g.:

======================

mName = "Macro1"

Call mName

========================

(I know the above doesn't work, but is there any similar method that does work?)

Many thanks.

[Chip Pearson]

Use Application.Run.

Application.Run mName


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"chubster264"
<[email protected]> wrote
in message
news:[email protected]...
>
> can you run a macro using its name stored in a variable?
>
> e.g.:
>
> ======================
> *mName = "Macro1"
>
> Call mName *
> ========================
>
> (I know the above doesn't work, but is there any similar method
> that
> does work?)
>
> Many thanks.
>
>
> --
> chubster264
> ------------------------------------------------------------------------
> chubster264's Profile:
> http://www.excelforum.com/member.php...o&userid=30164
> View this thread:
> http://www.excelforum.com/showthread...hreadid=498463
>

[chubster264]

Thanks for the suggestion - I'm getting an error 1004 though when I run the code as below... Any further suggestions as to what might be the problem?

Sub temp1()

MsgBox "hello"

End Sub

---------------------

Sub trythemacro()

Dim mName As String

mName = "temp1"

Application.Run (mName)

End Sub

[Chip Pearson]

Your code works fine for me. Try removing the parentheses from
the Application.Run statement.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"chubster264"
<[email protected]> wrote
in message
news:[email protected]...
>
> Thanks for the suggestion - I'm getting an error 1004 though
> when I run
> the code as below... Any further suggestions as to what might
> be the
> problem?
>
>
>
> Sub temp1()
>
> MsgBox "hello"
>
> End Sub
>
> ---------------------
>
> Sub trythemacro()
>
> Dim mName As String
>
> mName = "temp1"
>
> Application.Run (mName)
>
> End Sub
>
>
> --
> chubster264
> ------------------------------------------------------------------------
> chubster264's Profile:
> http://www.excelforum.com/member.php...o&userid=30164
> View this thread:
> http://www.excelforum.com/showthread...hreadid=498463
>

[Chip Pearson]

I should have added that your called code must be in a regular
code module, not a sheet module, form module, or the ThisWorkbook
code module.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Chip Pearson" <[email protected]> wrote in message
news:%[email protected]...
> Your code works fine for me. Try removing the parentheses from
> the Application.Run statement.
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
> "chubster264"
> <[email protected]>
> wrote in message
> news:[email protected]...
>>
>> Thanks for the suggestion - I'm getting an error 1004 though
>> when I run
>> the code as below... Any further suggestions as to what might
>> be the
>> problem?
>>
>>
>>
>> Sub temp1()
>>
>> MsgBox "hello"
>>
>> End Sub
>>
>> ---------------------
>>
>> Sub trythemacro()
>>
>> Dim mName As String
>>
>> mName = "temp1"
>>
>> Application.Run (mName)
>>
>> End Sub
>>
>>
>> --
>> chubster264
>> ------------------------------------------------------------------------
>> chubster264's Profile:
>> http://www.excelforum.com/member.php...o&userid=30164
>> View this thread:
>> http://www.excelforum.com/showthread...hreadid=498463
>>
>
>

[chubster264]

Chip,

Thanks so much! That nailed it.

I should have added that your called code must be in a regular
code module, not a sheet module, form module, or the ThisWorkbook
code module.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com