VB Code to run macro from cell

[rizmomin]

Hello:
Please refer to attached file.

I will be selecting the name of the macro from dropdown list in cell A1.
I need VB Code to run the macro named in cell A1.


Let me know if you have any questions.
Thanks.

Riz

[MarvinP]

Hey Riz,

Find the attached that does what I think you want.

RunMacro Select Case.xlsm

[rizmomin]

Hello MarvinP:

Thanks and this will be helpful.
However, my requirement is little different.

I may not have drop down list.

Basically i need to use Application.Run command with cell address.

For example:

If i need to run "My Work Book.xls'!Macro2" the text is in cell E2, i need VB code:

Application.Run Range("E2").Value, not user if this command would work.

So i will have full data of macros and depending on which one i need to run, i can define by its location

I hope this make sense.
So need correct code how to use Application.Run with cell reference.

Please let me know if you have any questions.
Thanks.

R

[MarvinP]

I was just reading about that at:

https://stackoverflow.com/questions/...h-a-string-vba

[rizmomin]

Hello Marvin:

Yes this article will help.
I will try and let you know if any more questions
Thanks a lot
Tiz

[rizmomin]

Hello Marvin:

Thanks a lot, above article was good and was able to implement and resolve my problem.
May be i will need further help as i complete my project.
Thanks
Riz