Where to insert progressbar macro in mulitple for loops

[waimea]

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I have an userform named Progress and I am using two for loops and I am having trouble with what value I should put in the CurrentProgress variable??

Please Login or Register  to view this content.

I have tried 1600 (40*40), 800 and I want help with what value I should use and where to put the progressbar code??

[waimea]

As it is right now the code goes to 2%, then restarts at 0% and I don't know why.

[Andy Pope]

Start by moving the call of InitProgressBar to outside of the loop.
To show progress through the outer loop replace ??? with 39, the upper limit of the loop.

I don't understand what the inner loop is doing. Why set the ListIndex of ComboBox4 to the values 0 through 39?

[waimea]

Thank you for your reply! I have moved the call of InitProgressBar to outside of the loop.

Imagine ComboBox1 and ComboBox2 being "County" and ComboBox3 and ComboBox4 are "Cities".

This iterates through the items in the ComboBoxes.

Ex. County0, City0 vs County0, City0
Ex. County0, City0 vs County0, City1
Ex. County0, City0 vs County0, City2
Ex. County0, City0 vs County0, City3
Ex. County0, City0 vs County0, City4

etc.

I want to show progress for the outer and the inner loop!

[waimea]

I think your suggestion with 39 worked like I wanted.

[Andy Pope]

Then you would need to move the progress code within the inner loop and keep a counter.

Please Login or Register  to view this content.

[waimea]

Thank you for your reply! This code works great!