Set Refresh Data Timer : Application OnTime « Application « VBA / Excel / Access / Word






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

Set Refresh Data Timer

 

Sub RunOnTime()
   Application.OnTime (Date + TimeSerial(10, 47, 0)), "RefreshData1"
End Sub








Related examples in the same category

1.Run on time
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.