To run a macro when the Change event occurs, set the OnChange property to the name of the macro.
You can use a Change macro to synchronize data in two controls; when a change occurs in one control, it can be reflected in the other control.
You can’t use the CancelEvent action in a Change macro.
Change Event — Event Procedures.