£2.95
LightboxAnimatedGif - display a Lightbox with easing and an Animated Gif as a Shape on the ActiveSheet to 'Lock out' user input whilst you complete some VBA Code task OR:
when Excel performs standard Formula Calculation on a Worksheet
LightboxAnimatedGif is the only true method I have found that allows Excel to perform its Calculations whilst displaying some type of Progress Indicator. Other methods that I have written and used over the years work well with VBA Tasks and indeed a couple pause during Calculations and then resume nicely, but always have some discernable jerk (or complete pause) when Excel goes into its non-stoppable Calculation Mode. This Software addresses the issue (where standard animations, threading, worker threads, HTML Web Browser animations etc. do not work) and finds a solution that you can use in your own Projects very easily to display to the end user that Excel is busy calculating. Combine this with an update on the Excel Statusbar or the standard Excel Calculations message on the Taskbar and you have a nice-looking, robust way of updating the end user of any progress. Check out the second image below where it is displaying the Calculation Percentage and the number of running Threads via the Excel Statusbar Messaging as the Loader is displayed and Animated without any pauses or stutters (Obviously check out the Videos to watch the entire animation process)
LightboxAnimatedGif uses a single Shape on a Worksheet, together with a single UserForm that allows you to use a nice easing effect to show and hide a Lightbox overlay. The Software uses a colourful Facebook style Loader that can be modified and downloaded from LoadingIO: Create and / or Download Animated GIF's Want a different Loader or Spinner - no problems just download your chosen animated gif (use Transparent = ON when downloading from loading.io) and then replace the one that you get when you purchase the Software
LightboxAnimatedGif allows you to align the Animated GIF in any number of positions on the Excel Window using the 'MsoAlignCmd' parameter ie. msoAlignTops, msoAlignMiddles, msoAlignCenters, msoAlignBottoms, msoAlignLefts, msoAlignCenters and msoAlignRights
4 Files are supplied in Total demostrating different animated GIF's
Online Documentation: