Excel Guides

Using a Progress Indicator in Macros in Excel

A progress indicator is a great way to let your users know that a macro is running, and to give them an indication of how long it will take. There are a few different ways to add a progress indicator to your macros in Excel. Here are some tips:

1. Use the Status Bar

The status bar is a great way to show users that a macro is running, and to give them an estimate of how long it will take. To use the status bar, simply add the following code to your macro:

Application.StatusBar = "My Macro is running. Please wait..." 

You can also update the status bar with information on how far along the macro is. For example, if your macro has 100 steps, you can update the status bar after each step like this:

Application.StatusBar = "My Macro is running. Please wait... (" & Step & "/100)" 

Just remember to set the status bar back to blank when your macro is done:

Application.StatusBar = "" 

2. Use a Userform

Another way to add a progress indicator is to use a userform. This gives you more control over the look and feel of your progress indicator, and also allows you to add other information such as estimated time remaining, etc. To use a userform, simply create a new form in Excel (Insert > Userform), and then add the following code to your macro:

(Form Name).Show 
(Form Name).Repaint 
DoEvents 
(Form Name).Hide 

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.