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