AJP Excel Information AJP Excel Information

Userform Clock


You can adjust the hands by moving the mouse over the clock face.
The left button controls the hour hand while the right button controls the minute hand.
In both cases the other hand will adjust to reflect the current portion of the hour.
The trick to animating the hands is to use a collection of label controls for each hand. The close proximity of the labels give the illusion of a solid line.
The construction, positioning and drawing of the hands are all done within a class module.
I initial idea for this came for a post, Time Picker, on Dick Kusleika's blog Daily Dose of Excel
Example workbook
Alternative links



Created August 2004
Last updated 5th August 2014 

Return to main page Chart Section VBA section Fun and games section Forum files Tips section Links section Book section Site information Site Search RSS feed Top of page

Microsoft® and Microsoft® Excel are registered trademarks of the Microsoft Corporation.
andypope.info is not associated with Microsoft. Copyright ©2007-2016 Andy Pope