Adding Progress Bar to existing Macro...

Hey guys, I am back again with some more questions...

and I thank everyone for all the help they have offered.

I have a sub routine (named MakeMyReport), for the most part, it just calls other subs to step through the whole process of making this crazy report.

I added a section that checks if there were results from a filter, if not it exits sub. bla bla bla

What I am trying to figure out, and I am not the best at doing all this... still learning, I am wanting to add a progress bar to show the progress as it goes through the routine.

I made a userform and all that, but I am having trouble incorporating it into this sub, as when I thought I had it (from many, many searches) all it would do is show a full bar and hang until i closed the userform window...

I will include the current code that I have, which everything works, just no progress bar.

The only reason that I am looking to add a progress bar is that at a certain point when it is retrieving data from other workbooks on teh network, it sometimes hangs and takes a while... so this way it would let the user know something is going on.

and the dang progress bars, for some silly reason, I just cannot wrap my head around!!! dang it!!


oh.. and please don't beat me up too much on what I have written.. I am still a novice...

Please Login or Register  to view this content.

and thank you for any advice and/or help!!!

Sorry about the long delay.. Holiday weekend and all..

although using the status bar is a good thing to do, i can tell you that none of the end users even look at the bottom of thier program windows, hence the graphical request.

I know that they don't pay attention to that area of the screen, as 4 of our other system programs that is used daily here post all error messages in the same location as the status bar for excel and still no one can give the error or message when they have a problem.. they just close it and expect us to use a crystal ball to decypher. haha

so, basically what I am trying to do is figure out some sort of a graphical progress bar on the screen, in thier face, so they do not get all 'click-happy".

Thanks..