AfterUpdate event

Occurs after data in a control is changed through the user interface.

Syntax

Private Subobject _AfterUpdate( )

The AfterUpdate event syntax has these parts:

Part	Description
object	Required. A valid object.

Remarks

The AfterUpdate event occurs regardless of whether the control is bound (that is, when the RowSource property specifies a data source for the control). This event cannot be canceled. If you want to cancel the update (to restore the previous value of the control), use the BeforeUpdate event and set the Cancel argument to True.

The AfterUpdate event occurs after the BeforeUpdate event and before the Exit event for the current control, and before the Enter event for the next control in the tab order.

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.