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
OnTimes counting, or renews the 3 minutes if the user clicks on a button.
I hope that makes sense.

Thanks.

Take a look at

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

In article ,
"gottahavit" wrote:

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
OnTimes counting, or renews the 3 minutes if the user clicks on a button.
I hope that makes sense.

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

--
Regards,
Tom Ogilvy

"gottahavit" wrote in message
...
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.