by x-treme (5 Submissions)
Category: Microsoft Office Apps/VBA
Compatability: Visual Basic 3.0
Difficulty: Beginner
Date Added: Wed 3rd 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.
Download Excel Timer let Excel perform periodical tasks (18 KB)