Hello All,

I have a macro that when selected, refreshes a data table from a Connect site. The macro, when selected, alerts the user that it may take a moment, and then gives an option to select ok or cancel. When selecting OK, there is a loading period of about 1 minute (+/-) to retrieve the updated information from the server. There is then another msg box that alerts the user that the task has completed.

What I am trying to accomplish is to have a scrolling progress/loading bar like the one I have attached that will fill that gap between the two msg boxes while the table refreshes. There doesn't need to be any relation between the progress bar and loading time, just simply a scrolling bar while the user waits. I appreciate any help you all can provide!

Progress Bar.png

Curtis