Progress Bar

[watson42]

Evening Guys & Gals,
I have a command button on a userform that runs 7 other macros. I would like to incorporate a progress bar while the macros run when the command button is selected. I have already created another userform that includes a frame and a label within the frame whose width is set to "0". Could someone help point me in the right direction with examples of code that would tie the Progress userform to the command button to run a progress bar.

Thanx

 

[dafan]

If you call all macros from a master macro you can use a variable (eg Progress) and add 100/7 everytime you call a macro.
You then show Progress in a cell or something so it reads 14%, then 28% etc.

With the Add-in Sparkmaker (never used it myself) you can make in-cell graphs. If you can make Bar graphs, you can plot that percentage in a cel making it a 'progress bar' going from 0% to 100%.