Use of Eval function to call VBA functions using string variable

[JrMontgom]

I have tried to use the following code


[Code]
Dim strProc As String
Dim strParam As String
Dim strTot As String
Dim bReturn As Boolean




strProc = "TestFuncCall"
strParam = Chr(34) & "Hello John" & Chr(34)


strTot = strObj & strProc & "(" & strParam & ")"
Debug.Print strTot
Debug.Print Eval(strTot) '**** Error occurs here '''can't find function TestFuncCall...


TestFuncCall (strParam) '++++ This works, definition: TestFuncCall(strName as string)as Boolean


[Code/]

Am I missing something? Thanks for any help

[hapm]

How the TestFuncCall function is declared? Should be something like: Public Function TestFuncCall(strName As String) As Boolean. The important thing is that it should be public.

[JrMontgom]

How the TestFuncCall function is declared? Should be something like: Public Function TestFuncCall(strName As String) As Boolean. The important thing is that it should be public.

I can't get the Eval("TestFuncCall("Hey John")) it gives me an error message whereas the VBA code calling the same function testFuncCall("hey John") worked. SO the question is why??

[June7]

strObj is not declared or set in the procedure.

It is possible to call procedures behind forms:
Debug.Print Form_FormName.TestFuncCall(strParam)
Debug.Print Forms("FormName").TestFuncCall(strParam)

Cannot get the Eval function to resolve form object variable.

Why do you need to refer to a function by variable? Why need to call function behind form?


BTW, end CODE tag should be [/CODE].