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. 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 >>
Digital Clock Tutorial - Part #3

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. 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 >>
Digital Clock Tutorial - Part #2

How to make a realistic looking digital clock in MS Excel – Part #2 – (how to move shapes with 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. 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 >>

Sprite Animation – what are sprites and how to use them in Excel animation

Introduction Hello everyone, in this section we will be talking about sprites and and how to use the sprites in MS Excel to create animation. This is going to be a general discussion, a demonstrative, introductory talk. It shows you what we can do with sprites in Excel. In general language, a sprite is a supernatural character like an elf or a fairy. Usually they are small and they can…

Read More >>

How to Create Wire Frame Shapes – Video Tutorial – Part 1

This is an introductory video about creating, scaling and animating wireframe shapes in MS Excel. The tutorial is made from the ground up starting with a blank workbook. A square is created. Scaling factors are added which can turn the square into a custom size rectangle. The tutorial demonstrate the use of VBA driven spin buttons and also VBA driven animation based on a “FOR” loop. The first half of…

Read More >>