Calling arbitrary procedures

[beliblis]

I would like to know how to call, from excel vba, an arbitrary procedure located in a module associated with a spreadsheet. Ideally it would work like this:
1) user enters a procedure name in a cell as plain text (eg, user enters "func_a" into cell A1)
2) some time later inside vba script, the value of this cell is read (some_variant = cells(1,1).value)
3) the script then executes a procedure named identical to the user's text (somehow call the function with the name identical to the string value of some_variant)

For the sake of simplicity, I will assume that the code for func_a is located in Module1 of the same workbook as the spreadsheet with [A1]="func_a". The point of this is that I do not want to limit the procedure names, so I cannot hard-code function calls based on the text. Code such as "if string="func_a" then call func_a" will not work, the user needs to be able to enter arbitrary procedure names. I have not been able to figure out how to do this with the vba "Call" statement, but maybe you can!

Thanks!

 

[Tazguy37]

Welcome to MrExcel Board!

Perhaps something like this will work:

Dim mySub As Variant

    mySub = Worksheets("Sheet2").Range("A1").Value
    Application.Run mySub

Hope that helps!