Syntax

expression.RegisteredFunctions(Index1, Index2)

expression A variable that represents an Application object.

Parameters

Name Required/Optional Data Type Description
Index1 Optional Variant The name of the DLL or code resource.
Index2 Optional Variant The name of the function.

Remarks

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.

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

If there are no registered functions, this property returns 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 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" 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
determine datatype return value dll function find out procedures in dll code resources get information about functions available registered registered functions Registered Functions Property RegisteredFunctions registeredfunctions property

See also: