This is a continuation tutorial, the third in the wire-frame tutorial series. Here we take the 2D basic house we created on an 2D scatter chart that had scaling, translations and rotation and replace all the cell formulas with two user defined functions (UDF). These basic tutorials use elementary math/geometry and trigonometry (middle school and high school level). As the… Read More... "Excel Animation Tutorial – 2D Wire-frame House #3 (adding UDF – user defined functions)"
Excel Animation Tutorial – 2D Wire-frame House #2 (adding rotation)
This is a continuation tutorial, the second in the wire-frame tutorial series. Here we take the 2D basic house we created on an 2D scatter chart and introduce rotation. These basic tutorials use elementary math/geometry and trigonometry (middle school and high school level). As the series progresses, the tutorials will reach 3D level and the creation of more complex shapes… Read More... "Excel Animation Tutorial – 2D Wire-frame House #2 (adding rotation)"
Excel Animation Tutorial – 2D Wire-frame House #1 (build, scaling, x&y translations)
In this tutorial, a very simple 2D house will be built from scratch. Three parameters, will then be set up to control the scale, x offset and y offset. A demo macro is then created to animate the house with the three parameters changing in time. The purpose of this tutorial is to demonstrate at a very basic level how… Read More... "Excel Animation Tutorial – 2D Wire-frame House #1 (build, scaling, x&y translations)"
Excel Animation – the Virtual Joystick Tutorial #2
>. This tutorial brings up an older topic from my blog, excelunusual.com. It is the second part of a short series, showing in detail, how to create a virtual joystick in MS Excel/VBA to serve as a game controller. The Excel file will be available for download on my blog, excelunusual.com. Enjoy! 0:00 Hello my friends and welcome back 0:02… Read More... "Excel Animation – the Virtual Joystick Tutorial #2"
Excel Animation – the Virtual Joystick Tutorial #1
>. This tutorial brings up an older topic from my blog, excelunusual.com. It is the first part of a short series, showing in detail, how to create a virtual joystick in MS Excel/VBA to serve as a game controller. The Excel file will be available for download on my blog, excelunusual.com. Enjoy! Hello my friends and welcome back today 0:02… Read More... "Excel Animation – the Virtual Joystick Tutorial #1"
The ActiveX Spin Button tutorial – VBA tricks for Excel Animation
>. This tutorial brings briefly introduces an older airplane/Ninja cat animation, then it shows how to flip a logic (Boolean) variable using the operator “Not”. Most of the tutorial however, is centered toward the Active X control button in Excel animation and the associated macro. It shows how to create and customize this button, then it shows how to introduce… Read More... "The ActiveX Spin Button tutorial – VBA tricks for Excel Animation"
The Start-Pause VBA Macro for Excel Animation, tutorial – part 3
By popular demand I am coming back to Excel after a long hiatus. This is the third in the series of beginner level tutorials targeted to building Excel animated models and games. >. This is the third part of the video tutorials about one of the most important Excel animation macros (or sub routines). It’s the “toggle” macro built pretty… Read More... "The Start-Pause VBA Macro for Excel Animation, tutorial – part 3"
The Start-Pause VBA Macro for Excel Animation, tutorial – part 2
By popular demand I am coming back to Excel after a long hiatus. This is the second in the series of beginner level tutorials targeted to building Excel animated models and games. >. This is the second part of the video tutorials about one of the most important Excel animation macros (or sub routines). I am reviewing there (with PowerPoint… Read More... "The Start-Pause VBA Macro for Excel Animation, tutorial – part 2"