Application OnTime « Application « VBA / Excel / Access / Word

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.The OnTime event
6.Scheduling a Macro to Run Every Two Minutes
7.Use OnTime to trigger the refresh data
8.writes the time to cell A1 and also programs another event five seconds later.