M
Mike
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
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