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

In article <[email protected]>,
"gottahavit" <[email protected]> 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
> OnTime’s counting, or renews the 3 minutes if the user clicks on a button.
> I hope that makes sense.

[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

--
Regards,
Tom Ogilvy

"gottahavit" <[email protected]> wrote in message
news:[email protected]...
> 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.
>