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.
- By Jon Peltier. Comment posted 06 September, 2009 2:49pmWhat's it tell you that I noticed "thirty" was misspelled in the screenshot?
- By John Walkenbach. Comment posted 06 September, 2009 3:59pmI'm surprised that you didn't notice the two other misspellings.
- By Jesse. Comment posted 16 September, 2009 4:57pmWhat would be more impressive is if the items like "twenty-" and "three" were not repeated but re-used as needed.
Spreadsheet Page Blog
Welcome to the Spreadsheet Page Blog. This is where you find the latest news on my books, add-ins, and other Excel-related topics. Comments are welcome.