IT Consultant – Java, J2EE, IBM WebSphere Portal, Lotus Notes/Domino
RSS icon Home icon
  • Excel – VBA Timer Example v1.0.1

    (9 votes) 1 Star2 Stars3 Stars4 Stars5 Stars
    Posted on 6 April 2002 Sebastian Thomschke*/?> 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.

    Read the rest of this entry »