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

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

10/03/2019

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

A minigun animation in MS Office – (work in progress)

04/08/2019

This ia a preview of a minigun animation, that I developed in MS Office. This animated model could be used in future Excel games. I created the graphics in PowerPoint while the animation is being run 100% by VBA code. Join our group to find out more: https://www.facebook.com/groups/excelunusual/

Read More >>

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

02/01/2019

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