Caller Property

Applies To

Application Object.

Description

Returns information about how Visual Basic was called (see the Remarks section for details). Read-only.

Remarks

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

Caller

Return

A custom function entered in a single cell

A Range specifying that cell

A custom function, part of an array formula in a range of cells

A Range specifying that range of cells

An Auto_Open, Auto_Close, Auto_Activate, or Auto_Deactivate macro

The name of the document as text

A command on a menu

An array of three elements specifying the command's position number, the menu number, and the menu bar number

A drawing object

The specifier of that object as a string

A button on a toolbar

An array of two elements specifying the tool position number and the toolbar name as text

A macro set by the OnDoubleClick or OnEntry properties.

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