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
Return to index