Engineers-Excel.com

Animation without Charts: How it works

Description| How it works



The animation in this app works using Conditional Formatting and a macro. Extensive use of conditional formatting is made to achieve the animation effects. Conditional Formatting is used to run the 7 segment display and the inputs LEDs, It is also used to change cell borders to create the effect of the switch being turned off and on and the ringing bell. As described in the Macro Overdose tip, the macro is used only for those effects that would not be possible to achieve using Excel features alone. As a result, the macro is quite short (less than a page of code). A Windows API function to create the sound effect.