OnTime

[Boomer67]

I use the

Application.OnTime Now + TimeValue("00:00:15"), "my_Procedure"

to trigger various procedures. At any one time I have several set up to run at irregular times. In order to cancel I need the exact time each is to be triggered. Is there any way of getting a lisitng of the times and subs that are due?

 

[tusharm]

No. You have to save that information somewhere before scheduling the event. See Chip Pearson's http://www.cpearson.com/excel/ontime.htm One change I would make to his page would be to replace

RunWhen as Double

with

RunWhen as Date

 

[Boomer67]

Thanks vm. I think that should solve my problems!