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

10/16/2019

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. The clock face is being created in PowerPoint out of MS objects (grouped collection of shapes). These objects are the digits (the clock…

Read More >>

How to make a realistic looking digital clock in MS Excel – Part #3 – (create a test “1-digit clock” – mainly VBA)

Digital Clock Tutorial - Part #3
10/15/2019

This is the second part of a series of tutorials explaining how to create a realistic clock in MS Excel using free form sprites. The sprites will be created in PowerPoint and imported in Excel as images. This part (part #3) demonstrates how to use very simple VBA code to: (1) detect position of shapes on the screen within an Excel worksheet using VBA and (2) how to reposition objects…

Read More >>

How to make a realistic looking digital clock in MS Excel – Part #2 – (how to move shapes with VBA)

Digital Clock Tutorial - Part #2
10/14/2019

This is the second part of a series of tutorials explaining how to create a realistic clock in MS Excel using free form sprites. The sprites will be created in PowerPoint and imported in Excel as images. This part (part #2) demonstrates how to use very simple VBA code to: (1) detect position of shapes on the screen within an Excel worksheet using VBA and (2) how to reposition objects…

Read More >>