Is there "pointer to a function" in VBA

  • Thread starter Thread starter Jag Man
  • Start date Start date
J

Jag Man

In many languages you can work with pointers to functions, allowing you to
"parameterize" your code with regard to the functions that get called.
Is there a facility to do this in VBA? For example, I'd like to do something
like this:

Sub functionOne( ByRef theFunction())
....
theFunction()
....
End Sub


TIA

Ed
 
You can do it with th ename of the procedure as a String:

Sub Sub2(SubName As String)
Application.Run SubName
End Sub

Sub Sub1()
Debug.Print "Hello, World!"
End Sub

In the Immediate Window:

Sub2("Sub1")
Hello, World!
 
If xl2000 or later, look at Addressof in help and see if that is what you
want. Generally, VB does not do pointers.
 
Thanks, Vasant . I think the syntax is:
Application.Run(SubName, arg, arg)

I got a compiler syntax error with
Application.Run SubName(arg, arg)

Ed
 
Back
Top