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

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

How to make a game of PONG in Excel – part #7

03/04/2011

This section of the tutorial explains how to add sounds to the Pong game created previously. There are four types of sound effects: collision with the walls, collision with the bats, missed ball by the player (crowd laughter) and missed ball by the virtual opponent (crowd applause). [sociallocker][/sociallocker]

Read More >>

How to make a game of PONG in Excel – part #2

02/24/2011

In this section two bats are created (the opponent’s bat and the player’s bat). The player’s bat movements are controlled by the vertical mouse movement. The geometry of movement, placement and charting of the bats are explained. [sociallocker][/sociallocker]

Read More >>