This documentation is archived and is not being maintained.

Application.Caller Property

Office 2007
Returns information about how Visual Basic was called (for more information, see the Remarks section).

Syntax

expression.Caller(Index)

expression   A variable that represents an Application object.

Parameters

NameRequired/OptionalData TypeDescription
IndexOptionalVariantAn index to the array. This argument is used only when the property returns an array (for more information, see the Remarks section).

Remarks

This property returns information about how Visual Basic was called, as shown in the following table.

CallerReturn value
A custom function entered in a single cellA Range object specifying that cell
A custom function that is part of an array formula in a range of cellsA Range object specifying that range of cells
An Auto_Open, Auto_Close, Auto_Activate, or Auto_Deactivate macroThe name of the document as text
A macro set by either the OnDoubleClick or OnEntry propertyThe 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 aboveThe #REF! error value

Example

This example displays information about how Visual Basic was called.

Visual Basic for Applications
Select Case TypeName(Application.Caller)
    Case "Range"
        v = Application.Caller.Address
    Case "String"
        v = Application.Caller
    Case "Error"
        v = "Error"
    Case Else
        v = "unknown"
End Select
MsgBox "caller = " & v



Show: