application.ontime

[msolari]

Is there a way to handle canceling application.ontime without any using "on error resume next"? I would prefer to be able to tell if and event is scheduled, and if so, then cancel. If no event is scheduled, then do nothing. Thanks in advance for any help.

Please Login or Register  to view this content.

[Oppressed1]

You could set a static (e.g. global) Boolean if your objective to prevent multiple invocations. Another idea, put logic, maybe time-driven logic, in pageFlipper to Exit Sub (guessing at your objective).

BTW, from cpearson.com: "There is no way to tell Excel to cancel the next OnTime event or to cancel all the pending OnTime events." I'm unclear why he says that, since Schedule:=False would seem to do that; maybe he means that multiple OnTime events would have to have Schedule:=False set on each individually. AAR, I've never gotten Schedule:=False to work; I get the error myself every time.

[Oppressed1]

After further study I see why the error has occurred for myself. I have been using OnTime like a timer, basing the scheduled time on the function Now. Making the arguments match precisely lets the :=false work as desired.

Assuming you weren't doing the same pinhead thing I was doing, and your arguments DO match, then I assume you get the error from multiple :=False invocations. So, back to my original suggestions. Try a Boolean.