The ActiveX Spin Button tutorial - VBA tricks for Excel Animation

preview_player
Показать описание
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 an upper and lower "rollover" property for this spin button. Finally it demonstrates how to turn the button's variable into an argument of a one-dimensional look-up-table (LUT).
Enjoy!

Keywords: excel, animation, Excel animation, VBA, Visual Basic for Application, game, gaming, Ninja cat, airplane, flight simulator, cell formulas, math, sprites, animation sprites
Рекомендации по теме
Комментарии
Автор

I'm impressed every time I stumble across these creations.

VonArnout
Автор

WOW! I'm a business Excel user and I'm really good at it. The way you're explaining stuff would save me years searching on Google. Great stuff. Sad that I didn't find you through Youtube search and only came here by accident. Your Makro is smart and on point. That Variable = Not(Variable) is awesome

XxXMrFloppeyXxX
Автор

These tutorials are just getting better (and the code feels simpler)

leonardosanchezaguirre
Автор

I'm really impressed that you made everything by yourself. Even the sprites. I was so sure you just downloaded them from somewhere but no you even made them. That's so awesome!

JenBytecode
Автор

7. The most important aspect: no matter what you want to do, start by thinking and experimenting before reading or asking someone else (no matter who).
Trust me on this one, you are far smarter than you think (if you dare to use your mind).
One month of continuous pondering and experimentation will get you farther than a year of school.
Learn slowly, speed is a big spoiler. The traditional education system is built on speed and superficiality.
“External teachers” were taught one thing: compliance. And that’s what they will teach you.
Trust your “inner teacher” instead. You won’t be disappointed.

-EngineeringFun

Thank you! you are unselfish my friend!

workhustlers
Автор

I hit in the subscribe button with the mouse (physical) 😀

mihaibrda
Автор

Hi George, Can we attach the sprite into 3D?

jhanolaer