VBA - Stop OnTime

[Minkowski]

hello everyone!
this may sound a bit silly but if i just change the time to 22:27:00
will it keep on running on 21:27:00 and then on 22:27:00?

or..if i want to delete the macro will it stop or forever running?

Sub ScheduleAProcedure()
   
    Application.OnTime TimeValue("21:27:00"), "MyMacro"

End Sub

thanks in advance

 

[VoG]

Hi. Unless you have some other OnTime code that will run once at 21:27:00

 

[Minkowski]

no just this one, that i want to change the time to

Sub ScheduleAProcedure()
   
    Application.OnTime TimeValue("09:30:00"), "MyMacro"

End Sub

i want to run it for 1 week and then delete the macro
so it stops

correct?

 

[VoG]

OK, you'll need to set a global variable for the OnTime time then stop that. Examples here http://www.ozgrid.com/Excel/run-macro-on-time.htm

 

[Minkowski]

So what you are saying is that if i just go and delete this macro
it won't make any difference
it will keep on running every morning???

yes i've read the part you send me
thanks for your time

 

[VoG]

Well, I don't think that you have posted all of your OnTime code if the event keeps recurring. If you set an OnTime event to occur in the future then it will run unless you stop it as in the link, irrespective of whether or not you delete the code that created it.

 

[Minkowski]

that is all the code nothing more.
i just tested it for 21:27:00 (to see if it works)
and now i changed the time to 09:30:00
so i haven't seen yet what will happen

thanks

 

[VoG]

If that is all your code then it will run once, as I said before.