Thanks to you both for the very valuble suggestions. The eval worked great! My final syntax was on the eval was
Eval (FunctionToRun & "()")
It took a few minutes for me to realize I needed to include the parens with quotes when it kept telling me it couldn't find the name referenced.
Many...
Greetings
I have a VBA module which has a number of procedures. I would like to create a function that would dynamically choose the procedure to run. I am querying the database and returning a result. That result is corresponds with the name of the procedure I want to run.
For instance, if...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.