/*sebthom-start*/?>/*sebthom-stop*/?> Posted on 6 April 2002 /*sebthom commented out: */?> 17 comments
A friend of mine asked me about how to let excel periodically update some worksheets.
So the first thing I did was searching the web for a solution in Visual Basic for Applications. But the only one I found was to use a 3rd party ActiveX timer control which you have to place onto a userform. Then I found the VBA command “Application.onTime” and had an idea.
Here is my solution only utilizing the VBA onTime command. No need for ActiveX control or any other 3rd party module.