VBA: Using pointers to functions

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:

Code:

---

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

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

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.

Excel VBA question moved to Office Development