LeaveCell Event

       

Occurs immediately before the currently active cell changes to a different cell.

Syntax

Private Sub object_LeaveCell()

The LeaveCell event syntax has one part:

Part Description
object An object expression that evaluates to an object in the Applies To list.

Remarks

This event is used to validate the contents of a cell.

This event does not occur when moving focus to a different control.