CADForums.net

smd · Guest

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

fantum · Guest

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")
...

	CADForums.net Forum Index -> VBA	All times are GMT
Page 1 of 1