OnTime or Wait functions

Hi Slyone2;

Seems to me you could do it this way:

Please Login or Register  to view this content.

And design all scheduled subs:

Please Login or Register  to view this content.

Hi Slyone2;

I guess I misunderstood your question. I thought that you were using macros to set the OnTime schedules. I was giving you some code to use instead of what I thought you were already using.

I now am guessing that you're hoping there is a way to see what is scheduled. Which I don't believe there is.

To simplify this, I would have to know how you are currently scheduling the OnTime procedures.

I set using this:

Please Login or Register  to view this content.

Would like something like this
A next run 4:00
B next run 4:10

My problem is there is no way to check if Ontime function is working.
And, when VBA crashes,I cant check if ontime is still set or DO i have to reset.

Hi Slyone2;
You can run your macros like this. That way if they are still set they would get cancelled before resetting them.

Please Login or Register  to view this content.