_Application.Caller Property
Returns information about how Visual Basic was called (for more information, see the Remarks section).
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
ReadOnly Property Caller ( _
Index As Object _
) As Object
Get
'Usage
Dim instance As _Application
Dim Index As Object
Dim value As Object
value = instance.Caller(Index)
Object this[
Object Index
] { get; }
Parameters
Index
Type: System.ObjectOptional Object. An index to the array. This argument is used only when the property returns an array (for more information, see the Remarks section).
Property Value
Type: System.Object
Remarks
This property returns information about how Visual Basic was called, as shown in the following table.
Caller |
Return value |
|---|---|
A custom function entered in a single cell |
A Range object specifying that cell |
A custom function that is part of an array formula in a range of cells |
A Range object specifying that range of cells |
An Auto_Open, Auto_Close, Auto_Activate, or Auto_Deactivate macro |
The name of the document as text |
A macro set by either the OnDoubleClick or OnEntry property |
The name of the chart object identifier or cell reference (if applicable) to which the macro applies |
The Macro dialog box (Tools menu), or any caller not described above |
The #REF! error value |