Excel Timer - let Excel perform periodical tasks!

Posted: 2002-06-01
By: ArchiveBot
Viewed: 69

Filed Under:

Visual Basic 6

A friend of mine asked me about how to let excel periodically update
some worksheets containing stock prices. 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 I had an idea.
Here is my solution only utilizing the VBA onTime command. NO need for
ActiveX control or any other 3rd party module.

Original Author: Sebastian Thomschke

Comments on this post

No comments have been added for this post.

You must be logged in to make a comment.