Table of contents
TOC
Collapse the table of content
Expand the table of content

BeforeUpdate Event

office 365 dev account|Last Updated: 6/12/2017
|
1 Contributor

Occurs before data in a control is changed. SyntaxPrivate SubobjectBeforeUpdate( ByVal_CancelAs MSForms.ReturnBoolean) The BeforeUpdate event syntax has these parts:

PartDescription
objectRequired. A valid object.
CancelRequired. 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 adata 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 receivesfocus). If you set the Cancel argument to True, the focus remains on the control and neither the AfterUpdate event nor the Exit event occurs.

© 2018 Microsoft