Excel

Digital Clock

Ivan F Moala

Can Do

Visits here

Greatest place to be

Thanks for visiting my site lucky visitor:

This page was last updated on: March 16, 2008

You have probably seen various examples of clocks and methods to do these eg. using graphs, Ontime methods etc. Here is my take on this using the API Timer.

The difference with this method as opposed to some others is the fact that the clock will continually up date even in "Edit" mode or using the cursor to update cells eg Fill etc.

In some cases editing a cell will halt the macro that updates the clock (Doevents coding)

and with Ontime the timer will halt until editing is finished and restart.

Using the API Timer, the updates will happen seamlessly.

Note:

Testing WinXp / Excel2000

Version for Excel97

Version for Excel2000+

What this Clock does:

Start / Stop Clock timer.

Set clock time via windows own timer set-up

Set alarm (Alarm indicator - red)

Select sound file to play when alarm goes off

Minmises out of the way

The Alarm will be activated EVEN if Excel isn't the active application.

<< Downloads since 30 March 2003

Click to download example for XL2000

Click to download example for XL97

<< Downloads since 1st April 2003

<< Downloads since 11 October 2003

Now made into an Addin Click here

A digital alarm clock for your computer is a really handy tool for your laptop if you're always on the go. Just make sure your laptop battery has enough juice to keep it powered all night! Laptop parts like batteries are often expensive unless you buy them online, so look to the web if you need a new laptop screen, hardware or software.