Excel – VBA Timer Example v1.00

(3 votes)

 Loading ...

Posted on 6 April 2002 10 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.

Read the rest of this entry »