_Calling a function with variable name...

From within a function, I want to call another function which name is an (String)argument of the function in which I am...
e.g. Call BATCH(ToDoFunction as String)... ToDoFunction is the name of a function wich is to be triggererd somewhere in the BATCH function... is this possible ? ... Thanks ... Zenomy

 

If your version of VBA is recent enough you can use CallByName:

In Class1:

Public Sub TestSub()
MsgBox "Hello, World!"
End Sub


In your BATCH function:

Public Function BATCH(ToDoFunction as String)
Dim C as Class1
Set C = New Class1

CallByName C, ToDoFunction, VbMethod

Set C = Nothing
End Function

In your calling code:

...
Call Batch("TestSub")
...