_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.Object

    Optional 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

See Also

Reference

_Application Interface

_Application Members

Microsoft.Office.Interop.Excel Namespace