Excel.Application.Caller.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Application.Caller property (Excel)	vbaxl10.chm133085	vbaxl10.chm133085	Excel.Application.Caller	0cfec08d-3cbc-0ab1-419a-f5b5702c3969	04/04/2019	medium

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

[!includeSupport and feedback]