A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Tot run a procedure (sub):
Application.Run "MyMacro"
or
Application.Run arrMacros(3)
where arrMacros is an array of strings, etc.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
In my Excel macro I have a string array containing the names of several SUBs. What is the code for calling the SUB whose name is in an element of that array?
(From somewhere in my programming past I have a memory of a built-in function called EVAL or some such that will do the job. But I cannot seem to find anything resembling it in Excel VBA.)
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Tot run a procedure (sub):
Application.Run "MyMacro"
or
Application.Run arrMacros(3)
where arrMacros is an array of strings, etc.