Dropdown Preloader with Easing for Excel Run Task and display an animated Facebook-style Preloader
Read more info:
https://www.kubiszyn.co.uk/documentat...
Purchase £2.99:
https://sites.fastspring.com/kubiszyn...
Introducing Dropdown Preloader for Excel
Did you know that in Office 365 you can add animated '.GIF's' directly into an Excel Worksheet? - you did? Good! Dropdown Preloader makes the most of this ability by manipulating the Row Height using various types of easing to create a Drop-down effect that seamlessly slides up and down from the top of the main Excel Window. Within that Row you can run a Macro to display an animated .GIF or Preloader whilst completing some task in Excel. You can also have any amount of Text or Icons and link these to parts of the Excel Document and open external file links such as a Webpage. Choose whether to have no Cursor flicker (we will change it to the xlNorthwestArrow) or to allow the Cursor to spin with the Hand Cursor as the Preloader slides up or down. Change the Height of the Row, the type of Easing and the Speed used for the animation. You can even Pause the animation for the GIF if you don't protect the User Interface for Objects. Dropdown Preloader does not use API calls, only a simple VBA Subroutine
You can use this technique together with Excel's Calculation when running Code to Copy Formula (something lots of us do, well, a lot). We will execute the Preloader using Code together with Application Calculate to recalculate a Range of Formula and display Excel's Calculation Status / Progress. There are not many procedures that actually allow an indicator of any kind to run as well as displaying Excel's Calculation progress
#vba #excel #kubiszyn #easing