Can I use 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)
End Function

Now GED_XKURT can be used as a spreadsheet function.

For developing Visual Basic applications, we recommend to use the NumXL SDK - C/C++, Java and VB callable object libraries.

Have more questions? Submit a request

0 Comments