The OnTime event : Application OnTime « Application « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Application
  3. Application OnTime

The OnTime event

 
Sub SetAlarm()
    Application.OnTime 0.625, "DisplayAlarm"
End Sub
Sub DisplayAlarm()
    Beep
    MsgBox "Wake up. It's time for your afternoon break!"
End Sub








Related examples in the same category

1.Run on time
2.Set Refresh Data Timer
3.If you want to keep refreshing the data on a regular basis, you can make the macro run itself
4.Using Application.OnTime to Periodically Analyze Data
5.Scheduling a Macro to Run Every Two Minutes
6.Use OnTime to trigger the refresh data
7.writes the time to cell A1 and also programs another event five seconds later.