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

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.

How to make a realistic looking digital clock in MS Excel – Part #3

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 (shapes or images) either absolutely in designated places or relatively to other shapes.