BeforeUpdate event

Occurs before data in a control is changed.

Syntax

Private Subobject _BeforeUpdate( ByValCancelAs MSForms.ReturnBoolean)

The BeforeUpdate event syntax has these parts:

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

• Microsoft Forms examples
• Microsoft Forms reference
• Microsoft Forms concepts

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.