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. |
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 earlier | 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
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.