score:0

after further reading i realised that vba simply does not support callback functions out of the box.

using xmlhttp.onreadystatechange is a viable solution but it would require to work around 2 limitations:

1) xmlhttp would have to be declared publicly in order to keep the object's scope available for the "callback" (this is fine).

2) the original function could not return a value so i would have to save the output in a procedure (instead of a "scalar" function that returns the output).


Related Query

More Query from same tag