Need to update progress bar from manual progress % to automatic running %

[Pankaj jaswani]

Dear Expert,

I've attached a file in which I've prepared a final version of the report dump using row data from supporting worksheets. I added a progress bar to my vba coding and didn't know how to connect it to my vba coding in running percent done, so I inserted a manual progress bar in the vba code steps using the google searched code. The progress bar and the code are both working, but the code is still slow in comparison to the data length (I tested it with 15K rows of data and it could be faster), so some modification is required. The progress bar is also working, but the progress is displayed in steps of 0%, 25%, 50%, and 100%, when I want it to show from 1% to 100%. Please help me to fix this two issues in my vba coding.

Thank you in advance.

[Pankaj jaswani]

Please help me on this post.

[Artik]

The nature of this macro does not allow increments of 1% because there are no loops in the four blocks of the procedure. Theoretically, you could create loops, but the macro would take much longer. I believe you should leave the progress bar display as is.

Artik

[Pankaj jaswani]

Could you help me in creating loop coding based on the existing code? Because I am a newbie in vba coding, I have made only minor changes to the coding provided by the vba expert on this forum. I also want to use a progress bar to show how far the coding has progressed.

[CheeseSandwich]

This progress bar will also slow down the overall run time.

If you must use one then it will be roughly as you have used it already due to the reasons @Artik has already pointed out.

You could have two loading bars - one for the main part of the code and one for the progress through that part. That being said looking at the code you will have to update both progress bars in the way you already have.

[Pankaj jaswani]

Okay! CS

I will update it the same.