This documentation is archived and is not being maintained.

Application.RegisteredFunctions Property

Office 2007
Returns information about functions in either dynamic-link libraries (DLLs) or code resources that were registered with the REGISTER or REGISTER.ID macro functions. Read-only Variant.


expression.RegisteredFunctions(Index1, Index2)

expression   A variable that represents an Application object.


NameRequired/OptionalData TypeDescription
Index1OptionalVariantThe name of the DLL or code resource.
Index2OptionalVariantThe name of the function.


If you don’t specify the index arguments, this property returns an array that contains a list of all registered functions. Each row in the array contains information about a single function, as shown in the following table.

1The name of the DLL or code resource
2The name of the procedure in the DLL or code resource
3Strings specifying the data types of the return values, and the number and data types of the arguments

If there are no registered functions, this property returns null.


This example creates a list of registered functions, placing one registered function in each row on Sheet1. Column A contains the full path and file name of the DLL or code resource, column B contains the function name, and column C contains the argument data type code.

Visual Basic for Applications
theArray = Application.RegisteredFunctions
If IsNull(theArray) Then
    MsgBox "No registered functions"
    For i = LBound(theArray) To UBound(theArray)
        For j = 1 To 3
            Worksheets("Sheet1").Cells(i, j). _
                Formula = theArray(i, j)
        Next j
    Next i
End If