This is the fourth part of a series of tutorials explaining how to create a realistic clock in MS Excel using free form sprites.
The sprites are created in PowerPoint and imported in Excel as images. This part (part #4) deals with planning the clock face layout.
How to make a realistic looking digital clock in MS Excel – Part #4
The clock face is being created in PowerPoint out of MS objects (grouped collection of shapes). These objects are the digits (the clock box or body, two digits for hours + two digits for minutes + two digits for seconds, the weekday sprites and the AM/PM label). After the layout is created, it will be imported in Excel, where a “analyze/record” VBA subroutine will be written.
This subroutine will record the sizes of all the objects imported and the relative position (x,y) of the objects with respect to the box. Another initialization subroutine will be written which can any time recreate the clock in Excel, using the data obtained by the first subroutine.
This action (in case that the clock was altered accidentally while in use) will restore the clock at the initial parameters. Also, having all this data in place, will allow to scale this clock model up and down dimensionally (i.e. make it smaller or larger depending of the user’s needs).
Nice Watch, I used the concepts from the training video. I was able to adapt it using Excel time clocking machine. Love concept. Thank you for sharing. I added Digital and analog option display. 12hr or 24 hrÂ
Thank you very much, Sammy!!!
Hello:
I was following along in the videos building the clock and also writing my own spreadsheet with VBA based on your videos. My primary purpose was to learn / improve VB skills. Unfortunately, I was ready to continue with the next lesson, after you did the layout of the clock and you were planning to detect all positions, the lesson stopped. I cannot find the next video. Can you please tell me if this project was stopped here.
Thanks
Paul
Hi George,
I found your blog website and amazing animations and also easy to follow structure in your posts.
A friend of mine and I are currently working on a website that aims to make it easier for beginners to browse new topics (we call them islands ;)).
We collect quality guides for these topics which link to one another in order to enhance the reading flow.
As you seem savvy with Excel, I would love to get your feedback & talk about how connecting your guides to guides from the community can make a difference on tiplister.
Let me know what you think.
Best regards,
Tassilo
Co-founder of https://www.tiplister.com Munich, Germany