Although xlUDF seems like a good solution for user defined callbacks
from an add-in, I cannot find much information on this.

What I've gathered is that it is not possible to call VBA macros with
this method. What use is xlUDF then?

Thanks!