Macros are among the best tools in Excel that allow us to save time.
Tasks that are repetitive, monotonous, and sometimes downright boring can be automated with VBA macros. This has the potential to reduce, in some cases, hours’ worth of work to minutes or seconds of work.
But not all macros can deliver on such performance claims. Sometimes the data is just too voluminous, and the computer can only operate so quickly. In extreme cases, things may move so slowly, we think the system might have locked or crashed.
Thus, the progress bar was invented.
In the early days of Windows, machines were understood to be slow and prone to crashes. By providing the user with a visual indicator of progress, we knew the system was still working and could make a reasonable guess as to when the task at hand would be completed.
VBA macros are tiny computer programs created by Users for Users. In those cases where macro execution may take a fair amount of time, a nice touch would be to provide users with a progress bar.
This post will demonstrate two variations on the same theme. One of these may serve as a complete solution or at a minimum inspire you to create your progress bar.