To run a macro when the Timer event occurs, set the OnTimer event property to the name of the macro.
You can’t use the CancelEvent action in a Timer macro. However, setting the TimerInterval property of the form to 0 prevents the Timer event from occurring.
Timer Event — Event Procedures.