Account Login  Username:  Password: 

Excel Timer let Excel perform periodical tasks

by x-treme
Category: Microsoft Office Apps/VBA
Compatability: Visual Basic 3.0
Difficulty: Beginner
Date Added: Wed 3 February 2021
Rating: (23 Votes)

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.

Rate Excel Timer let Excel perform periodical tasks

Download Excel Timer let Excel perform periodical tasks

Download Excel Timer let Excel perform periodical tasks (18 KB)

Excel Timer let Excel perform periodical tasks Comments

No comments have been posted about Excel Timer let Excel perform periodical tasks. Why not be the first to post a comment about Excel Timer let Excel perform periodical tasks.

Post your comment

Subject:
Message:

0/1000 characters