Application OnTime Refresh

Good morning,

I have a macro named "UpdateScreen" that ends with Application.OnTime Now + TimeValue("00:01:00"), "UpdateScreen" so it runs it again 1 minute later.
The problem is that the workbook contains a "Refresh" button so it can be refreshed at any time manually. On running this macro it triggers the OnTime again, meaning itll run twice in the space of 60 seconds.
The more you click it the more it runs in a minute.

Is there a way to cancel the OnTime just before it is called so that the timer resets whenever the "UpdateScreen" macro ends?

Thank you

To cancel an OnTime you need to store the exact time the event is scheduled and call OnTime again passing that time and setting the Schedule Parameter to False.

This means you need to declare a module level variable to hold the time, set that variable with the calculated event time and then call OnTime.

Narrative answer only, using a phone, but there are plenty of examples around the forum.

Perfect thank you cytop, Leelnich just provided the code for exactly what you were referring to so thank you

Thank you Lee that's done the job.
Thank you again.