ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Run macro which name is cell value (https://www.excelbanter.com/excel-programming/363208-run-macro-name-cell-value.html)

eLaCiD

Run macro which name is cell value
 
Hi

Need way how to run macro which name is cell value
Example :

Click on button (or any shape) will run macro which name is in cell A1




Norman Jones

Run macro which name is cell value
 
Hi eLaCiD,

Try assigning the following macro to the button / shape:

'=============
Public Sub TesterA()
Application.Run (Range("A1").Text)
End Sub
'<<=============


---
Regards,
Norman


"eLaCiD" wrote in message
...
Hi

Need way how to run macro which name is cell value
Example :

Click on button (or any shape) will run macro which name is in cell A1






eLaCiD

Run macro which name is cell value
 
Thanks Norman

fast again as allways :))




All times are GMT +1. The time now is 03:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com