Applies To
Application Object, Worksheet Object.
Description
Returns or sets the name of the procedure that runs when you enter data using the formula bar or when you edit data in a cell. Read-write.
Remarks
The procedure does not run when you use edit commands or macro functions.
Set this property to empty text ("") to remove the procedure.
To determine which cell had data entered in it, use the Caller property.
Example
This example runs my_Worksheet_Entry_Procedure when data is entered on Sheet1.
Worksheets("Sheet1").OnEntry = "my_Worksheet_Entry_Procedure"
This example disables the OnEntry procedure for Sheet1.
Worksheets("Sheet1").OnEntry = ""