I haven't written a Progressbar for ages but after stumbling across a HTML5 CodePen by Stas Melnikov I simply had to write one for Excel in a similar style. Of course it would not as good as the HTML5 one as I am bound by the IE7 WebBrowser Control (lacking many Javascript & CSS commands) and I do not want to configure registry settings or use an IE Object. Anyhow, I think with the limitations I have, I have sort of done it justice - it certainly took a while to get the HTML right!

I have tried to emulate a kind of skipping technique, whereby for small periods of time the Bar appears to be stationary and then jumps up in small Percentages - this looks similar to the technique Stas employs for his demo

This Progressbar can be used with DoEvents or an alternative MyDoEvents to display the Percentage and Message of a Task until it is complete, after which it can Fade away or display a Complete Page with Message. I have added the Easing function to slow the rate of the Bar down as it reaches conclusion and the Workbook comes with many examples so you can get a feel as to what can be done including some 'real world' examples

Required:
Windows 7/10, Excel 2010 or Excel 2013 (32bit or 64bit). Some knowledge of VBA to Copy & Paste Code into respective Code Modules in your own Projects

Features include:

Create a Progressbar to display the Percentage/Bar remaining of the task with a Message
Use an Easing technique to accelerate or decelerate the Percentage/Bar
Adapt a stylistic, skipping technique to your tasks to display a beautiful Progressbar (check out the Video on YouTube)
Change the Progressbar Background and Font Colours/Sizes
Change the way that the Progressbar is destroyed ie. Fade out, Fade out with HTML Complete Page or Fade out with user Close Button
Use HTML formatting for the Progressbar Message
Run multiple tasks where each task is given 100% before the next task begins
Hide the Close Button on the Complete Page
Change the Width and Height of the Progressbar
Lots & lots & lots of examples included, 36 examples for Version 1.1
The HTML, CSS & Javascript shows you how to:
- prevent F5 and CTRL+F5 from being pressed
- prevent the Right-click context menu from being displayed
- prevent Text Selections for specific HTML elements
- remove all scrollbars from a WebBrowser Control


Use the links above to purchase Progress or read online documentation and watch a video of Progress on YouTube. You can also Share this article to Twitter, Facebook or Google+ using the links at the bottom of this page