Simple Timer

Those nice folks at Codematic have made available their world class, best of breed, exclusive multifunctional chronography system.

(= a simple VBA Timer/Timesheet thingy, nowt special, from here.)

It has a couple of buttons, one to start the timer, one to end it. It records the interval and moves to a new line each time you click start.


Say for example you want to prove who can get the coffees in the fastest.

Or time how long a long procedure takes, like say some massive ETL process.

If I’d used GetTickCount instead of NOW() it could be used for some more high definition timing, maybe version 2.

Dick at DDOE did a more feature rich one recently related to measuring the amount of time spent on various categories of task during the week.

This one is just a simple timer, originally created to measure some 20 minute network based procedure to see if it could be speeded up. (Yes – work locally!). I rushed it on-line in response to a NewsGroup posting the other day, otherwise I might have spent more time tidying things up.

The code is totally open (all 10 lines of it) feel free to modify/enhance – let us know if you do something we might all benefit from.

No VBA code runs between start and stop and no variables are held in memory, so you can even time compiling your VBA.

As usual any feedback welcome



Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: