OnTime

[gottahavit]

Is there a way to stop OnTime once it starts counting, or to renew the time?
I have a macro that uses OnTime that waits for 3 minutes before running
another procedure. I want to be able to have another macro that either stops
OnTime’s counting, or renews the 3 minutes if the user clicks on a button.
I hope that makes sense.

Thanks.

 

[JE McGimpsey]

Take a look at

http://cpearson.com/excel/ontime.htm

 

[Tom Ogilvy]

You would have to cancel the pending ontime event and begin a new one.

See Chip Pearson's Ontime page for ideas:

http://www.cpearson.com/excel/ontime.htm