Progress bar

[SirKT]

Hello

This would be a concatenation of a progress bar with an existing automation. Please click open the attached file, macro button1 called 'Move Data' which consolidates & copy data by creating new sheets.
Can we add a progress bar to show progress instead of a circle rotating while macro runs?

P.s: I tried adding an userform with a progress bar but error registering library. Please help

 

[Nebu]

Hope this link will help you
http://www.experts-exchange.com/Sof...s-Bar-for-Excel-and-Other-Microsoft-Apps.html

 

[Nebu]

Hi:
I have done something crude , Progress bar will work only if it is in a loop, and the user have to decide what is the minimum and maximum. I am not sure why your code throw an error if I delete all the data from sheet1 and try to run the macro, so cud not test it properly. The progress bar is anyways working based on the no of rows in your sheet1. Please check and let me know.

Thanks
Nebu

 

[SirKT]

@Nebu : Brilliant!

My observations:
-Progress bar is tweeked to match with the automation
-Have you noticed the time taken to finish up the work is drastically more (X10 times~)

However, I do appreciate your try. Thanks

 

[Nebu]

Hi:
Yes it will add up extra time coz of the extra loop I had to put in for the progress bar. If it adding time for the report to run, and the progress bar is not a critical requiremnet you may well skip the idea of progress bar , unless if u can find a way to reduce the time...

Thanks
Nebu