Applies To
CheckBox control, ComboBox control, ListBox control, OptionButton control, ScrollBar control, SpinButton control, TextBox control, ToggleButton control.
Description
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.
See Also
AfterUpdate event, BoundValue property, Change event, RowSource property, UndoAction method.