Can I use the NumXL function with VBA or in an Excel macro?
NumXL is an Excel add-in and is compiled for high speed. For this reason, it cannot be accessed directly from Visual Basic or from macros. Nevertheless, you can use NumXL indirectly from Visual Basic for Applications (VBA) within Excel only by using the "Run" command. For example:
Public Function GEDi_XKURT(a)
GED_XKURT = Run("GED_XKURT", a)
Now GED_XKURT can be used as a spreadsheet function.
For developing Visual Basic applications, we recommend using the NumXL SDK - C/C++, Java, and VB callable object libraries.