Macro Application Question

[lawre2000]

Hello All, I implemented the "custom dual progess bar" per the instructions in the link below and the demonstration works good ("ShowForm") in my file. However, it is not being applied to the macros that already exist in my file. Is there possibly some code missing which would show allow me to have the progress bar apply to all macros within my file? Thanks!

Custom Dual Progress Bar.

 

[Richard Schollar]

Hi

You need to call the userform/progress bar from within each macro with the following code line:

ProgressBar.Show

Note that each macro will likely have different run times, so the applicability of the variables used in the userform code is questionable.

 

[lawre2000]

Thank you, that helps. I was thinking that the timing would be in conjunction with the actual run time of the macro but I now see that I have to manually update to actual macro run time. Thanks!