BeforeUpdate Event
Occurs before data in a control is changed.
Syntax
Private Sub object_BeforeUpdate( ByVal Cancel As MSForms.ReturnBoolean)
The BeforeUpdate event syntax has these parts:
| Part | Description |
|---|---|
| object | Required. A valid object. |
| Cancel | Required. Event status. False indicates that the control should handle the event (default). True cancels the update and indicates the application should handle the event. |
Remarks
The BeforeUpdate event occurs regardless of whether the control is bound (that is, when the RowSource property specifies a data source for the control). This event occurs before the AfterUpdate and Exit events for the control (and before the Enter event for the next control that receives focus).
If you set the Cancel argument to True, the focus remains on the control and neither the AfterUpdate event nor the Exit event occurs.