How to make a realistic looking digital clock in MS Excel – Part #4 – (create a clock face layout – PowerPoint design)

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).

1 Comment

  1. 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,
    Co-founder of Munich, Germany

Leave a Reply

Your email address will not be published.