Programming Excel with VBA and .NET

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