J-Walk & Associates, Inc.

Word Clock Posted

If you're a fan of useless Excel apps, here's one for you: Word Clock.

It's a very impractical way to get the current date and the time of day. It's basically a VBA implementation of a screen saver written by Simon Heys.

It uses the Application.OnTime method to update the text in a Shape every second. Writing the code was a lot easier than I thought it would be.

This download is for Excel 2007 and later. I was going to re-write it for previous versions, but then I realized that it's not worth the effort.

- Reader Comments -

Following are comments in response to this item.
The most recent comment is at the bottom.

1. By Jon Peltier. Comment posted 06 September, 2009 2:49pm

   What's it tell you that I noticed "thirty" was misspelled in the screenshot?
2. By John Walkenbach. Comment posted 06 September, 2009 3:59pm

   I'm surprised that you didn't notice the two other misspellings.
3. By Jesse. Comment posted 16 September, 2009 4:57pm

   What would be more impressive is if the items like "twenty-" and "three" were not repeated but re-used as needed.