Skip to content

Latest commit

 

History

History
59 lines (37 loc) · 2.11 KB

change-event.md

File metadata and controls

59 lines (37 loc) · 2.11 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Change event
fm20.chm5224938
fm20.chm5224938
Office.Change
4bf23772-5ae0-dc1d-1152-b7ea01f7e702
11/15/2018
medium

Change event

Occurs when the Value property changes.

Syntax

Private Subobject _Change( )

The Change event syntax has these parts:

Part Description
object Required. A valid object.

Settings

The Change event occurs when the setting of the Value property changes, regardless of whether the change results from execution of code or a user action in the interface.

Following are some examples of actions that change the Value property:

Remarks

The Change event procedure can synchronize or coordinate data displayed among controls. For example, you can use the Change event procedure of a ScrollBar to update the contents of a TextBox that displays the value of the ScrollBar. Or you can use a Change event procedure to display data and formulas in a work area and results in another area.

Note

In some cases, the Click event may also occur when the Value property changes. However, using the Change event is the preferred technique for detecting a new value for a property.

See also

[!includeSupport and feedback]