£3.95
Introducing Dropdown Preloader for Excel
Dropdown Preloader with Easing for Excel (32bit or 64bit, Version 16, Office 365) · CHECK BEFORE PURCHASING! You MUST be able to insert animated gif's into excel to use this Software - see Prerequisites below
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
Prerequisites
Microsoft Excel 2016 Version 16 (32bit or 64bit) · designed for Office 365 Windows 11. Please check that you can actually 'Insert' an Animated Gif into Excel and that it animates. If it looks like the image below after inserting an animated Gif then your Excel Version will not work with this Software! You should see a Play and Pause button and some animation - download this animated image and try inserting it into your Excel Animated Facebook Gif - once opened in a new Window do Right-click, Save as ... If all looks good then you can purchase this Software with confidence that it will work okay with your Excel version
Online Documentation/Help/Features/Credits:
https://www.kubiszyn.co.uk/documentation/dropdownpreloader.html
Please note: this Software is released under an MIT license and as such you must attribute the author, Mark Kubiszyn whenever distributing or remixing the work