Hi

Been Trying to figure out how to declare a Variable for 2 Application On Time events in excel VBa

These events (Macro's) get called by another Macro then they have to wait for 10 - 20 minutes, when the time to run arrives they don't run.

Have read that "(EarliestTime argument) should be assigned to a variable to store it".

"(EarliestTime argument)" is in Cell $X$9 and $W$11 16:40:15 time format


Any help appreciated, Thanks


Sub settimers()

Application.OnTime TimeValue(Range("$X$9").Text), "StartBlink"
Application.OnTime TimeValue(Range("$W$11").Text), "StopBlink"

End Sub