Assign Macro

[rizmomin]

Hello:

Please refer to attached file.
I need VB code to assign the "Macro1" Button to run Macro which is in cell C1

Let me know if you have any questions.
Thanks.

Riz

[Tsjallie]

If the button is a Forms object and assuming that the name of the macro is in cell C1 then

Please Login or Register  to view this content.

Change the sheetname to your needs.

[rizmomin]

Hello Tsjallie:

Thanks, it seems to work.
However, i have few questions:
How would i use above code if i have multiple sheet and all sheet will have macro location in Cell C1.
Also in my all sheets, i have lots of macro assigned button so how would i know the name of the Button in above code.
Please let me know if you have any questions.
Thanks.

Riz

[Tsjallie]

You could add this code to the codemodule of ThisWorkbook.
But you should decide on a standard name for the button to assign the macro to.
Or have the name of the button in an other cell.

Please Login or Register  to view this content.

[shg]

@riz: You're not expecting that to change dynamically when you change the name of the macro in the cell, correct?

[mikerickson]

You could assign the button to this routine

Please Login or Register  to view this content.

[rizmomin]

Hello Guys:

I am sure i will be able to use any of the code above to fit my requirement.
Thanks a lot and will contact if further help is needed.

Riz