My SpreadSheet Magic

Cool Analog Clock in VBA

Here is a very good source in creating fancy analog clock with VBA and excel chart.
URL1: http://www.j-walk.com/ss/excel/files/clockchart.htm
URL2: http://www.andypope.info/fun/clocks.htm

Overview

This workbook contains an XY chart that displays a working analog clock.
It uses VBA to update the clock every second. This is really not a
"practical" application. Rather, it's an interesting charting demonstration
that uses VBA. The VBA project is not protected, so you can view the code.

Free Download

Click the link below to get a copy of this file. It works with Excel
97 or later.

• Download the Clock Chart Workbook (107K)
  
  
  The file (clockchart.exe) is a self-extracting archive. After downloading, execute
  clockchart.exe to extract clockchart.xls.
  

posted by Noel J @ 9:03 AM