RegisteredFunctions Property

Applies To

Application Object.

Description

Returns an array containing a list of functions in dynamic-link libraries (DLLs) or code resources that were registered with the REGISTER or REGISTER.ID functions. Read-only. Each row in the array contains information about a single function, as shown in the following table.

Column	Contents

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

Remarks

If there are no registered functions, the property returns Null. Use the IsNull function to test the return value for Null.

Example

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

theArray = Application.RegisteredFunctions
If IsNull(theArray) Then
    MsgBox "No registered functions"
Else
    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