Application.Caller Property (Excel)
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
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Index |
Optional |
Variant |
An 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.
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 |
Example
This example displays information about how Visual Basic was called.
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