Posted on 2002-06-19
I need a full run down on how to use the OnTime event. The online help for this topic is as much use as udders on bulls - so that is not a solution.
The specific problem is twofold:
Starting when a Global boolean variable named TestStarted is True then
1. Every 60 seconds, Application.Calculate
2. Every 60 seconds:
If WorkSheets("Score").Range("D11").Value >= WorkSheets("Admin").Range("C38").Value then
A code solution that is able to be implemented in reasonable time, with sufficient explanation will get a B
A code solution, and a description of how OnTime works - a description that is better than online help and Welkenbach's VBA Programming [both of which are useless on this topic] will get the A
Urgently needing help.