Change
Indicates the contents of a control have changed. How and when this event occurs varies with the control:
-
ComboBox — changes the text in the text box portion of the control. Occurs only if the Style property is set to 0 (Dropdown Combo) or 1 (Simple Combo) and the user changes the text or you change the Text property setting through code.
-
HScrollBar and VScrollBar (horizontal and vertical scroll bars) — move the scroll box portion of the scroll bar. Occurs when the user scrolls or when you change the Value property setting through code.
-
Label — changes the contents of the Label. Occurs when a DDE link updates data or when you change the Caption property setting through code.
-
TextBox — changes the contents of the text box. Occurs when a DDE link updates data, when a user changes the text, or when you change the Text property setting through code.
-
Slider — generated when the Value property changes, either through code, or when the user moves the control's slider.
-
Toolbar — generated after the end user customizes a Toolbar control's toolbar using the Customize Toolbar dialog box.
Syntax
Private Sub object.Change([index])
The Change event syntax has these parts:
| Part |
Description |
| object |
An object expression that evaluates to an object. |
| index |
An integer that uniquely identifies a control. |
Remarks
The Change event procedure can synchronize or coordinate data display among controls. For example, you can use a scroll bar's Change event procedure to update the scroll bar's Value property setting in a TextBox control. Or you can use a Change event procedure to display data and formulas in a work area and results in another area.
Note A Change event procedure can sometimes cause a cascading event. This occurs when the control's Change event alters the control's contents, for example, by setting a property in code that determines the control's value, such as the Text property setting for a TextBox control. To prevent a cascading event:
-
If possible, avoid writing a Change event procedure for a control that alters that control's contents. If you do write such a procedure, be sure to set a flag that prevents further changes while the current change is in progress.
-
Avoid creating two or more controls whose Change event procedures affect each other, for example, two TextBox controls that update each other during their Change events.
-
Avoid using a MsgBox function or statement in this event for HScrollBar and VScrollBar controls.