What you need to do with that progress bar is change the width of the 'BarColor' label to indicate how far it's gotten. If you have a numbered loop anywhere in your macro (for example a FOR NEXT loop that counts down rows of data) then you simply divide the max width of the label (264 in this case) by the total number of rows and then multiply it by the row number you're on.
For example, in my code:
And every time the loop cycles:
If you don't have a numbered loop you can use then you'll just have to put hard coded width updates at various points in your code.
Bookmarks