ON.ENTRY

Macro Sheets Only

Runs a macro when you enter data into any cell on the specified sheet.

Syntax

ON.ENTRY(sheet_text, macro_text)

Sheet_text is a text value specifying the name of a sheet in a workbook. If sheet_text is omitted, the macro is run whenever you enter data into any sheet or macro sheet.

Macro_text is the name of, or an R1C1-style reference to, a macro you want to run when you enter data into the sheet specified by sheet_text. The name or reference must be in text form. If macro_text is omitted, entering data reverts to its normal behavior, and any macros assigned by previous ON.ENTRY functions are turned off.

Remarks

• The macro is run only when you enter data in a cell, not when you use edit commands or macro functions.
• To determine what cell had data entered into it, use a CALLER function in the macro specified by macro_text.

Related Functions

ENTER.DATA Turns Data Entry mode on or off

ON.RECALC Runs a macro when a workbook is recalculated

List of Customizing Functions