VBA: Using pointers to functions

[Steve06]

Hello,

At the moment I'm programming in VBA6 for Excel 2003. I've a decent C/C++ background and wonder how I can implement the following in VBA:

I want to declare a function, which accepts a pointer to another function as an argument, and then is able to call this pointed function.

An example in C:

float myfuntion(void (*inputfunction)(float, float*, float*), float x1, float x2)
{
...
(*inputfunction)(x1, &fl, &fh)                                  // calling the function
...
}

Thank you very much for your help.

Regards,
Steve

[penagate]

In short, you can't really, not like that anyway.

What you can do, however, is use CallByName to call a function by passing a string containing its name. This does require that the function is an object method (and public, obviously).

[Joacim Andersson]

I once showed how you can use CallWindowProc to be able to call functions with a pointer. The draw-back is that the function you want to call (using the pointer) must accept exactly 4 arguments. Anyway here is the CodeBank post that shows you how to do it.

[Hack]

Excel VBA question moved to Office Development