Progress bar for macro with loop

I have a button that will trigger this. It's a long macro but this is the part i want to focus on.

Please Login or Register  to view this content.

How will i create a progress bar while that part of macro is running. I already placed ProgressBar1 in the userform.

This makes the progress bar run. I neep help modifying it so when I run the code, the progress bar will run depending on the progress of my condition

Please Login or Register  to view this content.

Bump. Anyone, please?