Name

Application.RegisteredFunctions

Synopsis

Returns an array of DLL functions registered with Excel. The following code displays a list of the registered functions:

Sub TestRegisteredFunctions(  )
    Dim i As Integer, func
    func = Application.RegisteredFunctions
    Debug.Print "DLL", "Function", "Arguments/Return type"
    If Not IsNull(func) Then
        For i = 1 To UBound(func, 1)
         Debug.Print func(i, 1), func(i, 2), func(i, 3)
        Next
    Else
     Debug.Print "No functions registered."
    End If
End Sub

Get Programming Excel with VBA and .NET now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.