Excel updating categories

12 Jun

I have written a couple of cover macros in Class Progress Bar V2.01to illustrate how to use this progress bar; I also have and example that uses two progress bars simultaneously.

Let me know if you get stuck somewhere, I will be happy to help.

To make it little interesting, has two sheets, with sales header data in Sheet1 and sales detail in sheet2.The VBA For Loop and the Do While loops are the two most important loops in the VBA language.They can be used to carry out a specific task in an iterative manner till such time that a condition is met (or the VBA loop is terminated).The progress bar that I developed earlier, is one of my most visited posts, and I thought I have to reward my readers with a progress bar that is much more easier to use.Feel free to rearrange the Form Controls however you please, but remember to not play around with the names though.