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 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). The Excel file is available for download by clicking the green download button above. Download by hitting the light green button above. Enjoy!

Tutorial level: beginner

Thanks for your support!

1 Comment

  1. Plse give basics of vba and excel .all are very advanced

Leave a Reply

Your email address will not be published.