Passing parameters to dynamic named function

Question

I want to call a function with a dynamic name, which can be done with Eval:

fName = "TestFunction"
Call Eval(fName)

This works great, but how do I pass parameters to this function call? Something like this doesn't work:

Call Eval(fName)(Param1, Param2)

MC ND · Accepted Answer · 2014-09-16 12:20:00Z

3

If you use Eval you need to prepare the code to execute

Call Eval(fName & "(" & Param1 & "," & Param2 & ")" )

What you are trying needs GetRef

Call GetRef(fName)(Param1, Param2)

answered Sep 16, 2014 at 12:20

MC ND

71.1k8 gold badges95 silver badges136 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Bond · Accepted Answer · 2014-09-16 12:18:45Z

0

Function Add(int1, int2)
    Add = int1 + int2
End Function

intSum = Eval("Add(1, 2)")
' or...
intSum = Eval("Add(" & intParam1 & ", " & intParam2 & ")")

answered Sep 16, 2014 at 12:18

Bond

16.3k6 gold badges34 silver badges56 bronze badges

Collectives™ on Stack Overflow

Passing parameters to dynamic named function

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related