Run on time : Application OnTime « Application « VBA / Excel / Access / Word






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

Run on time

 

Sub RunOnTime()
   Application.OnTime Date + TimeSerial(15, 0, 0), "RefreshData"
End Sub








Related examples in the same category

1.Set Refresh Data Timer
2.If you want to keep refreshing the data on a regular basis, you can make the macro run itself
3.Using Application.OnTime to Periodically Analyze Data
4.The OnTime event
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.