Progress Bar

watson42

New Member
Joined
Jun 15, 2008
Messages
25
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
 

Some videos you may like

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

dafan

Well-known Member
Joined
May 6, 2008
Messages
692
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%.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,477
Messages
5,601,893
Members
414,479
Latest member
Beau the dog

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top