Need help showing progress bar

I want to add a progress bar to a macro that I currently use..

I tried this useful link but I could not get the code to work with the macro I am using.
http://www.excelforum.com/excel-prog...gress-bar.html

I already created a form and label, just need to add a progress code to it and activate the form to show when I ran the macro. The above link expects the code to be set in the forms but I have the macro code in a Module. How can I tie the two(code in userforms and code in Module) together and make the progress code to work?

Below is part of the code that keeps looping from the macro. I guess I need to set progress points somewhere in the loop?? but I don't know where or how to. Please help..thx

Please Login or Register  to view this content.

up ^
||