progress bar

[GuitarMyke]

Hey Guys,

I have a project that involves saving a rather large workbook. The end user tends to think that nothing is happening while the workbook is trying to save. I need a progress bar so that the user knows the macro is actively executing the save. I have seen the examples by Walker and others and they're not really what I'm searching for. The progress bar that Walker shows has to do with generating random numbers on a worksheet and showing the progress of that. I don't want to use a progress indicator in the status bar because the user's attention isn't automatically drawn to it. I need an actual progress bar that shows while the workbook is saving. Also, how do I use the progress bar control? I think that this would be the easiest way, though I could be wrong. I couldn't find any help in the help files or on the web. Any help?


Thanks in advance,
Myke

[VBA Noob]

So this didn't help

http://www.excelforum.com/showthread.php?t=612204

Please read forum rules below. Duplicate posts are not permitted.

VBA Noob

[GuitarMyke]

No, that post didn't help to much. Sorry about the duplicate post. I guess I didn't make my situation clear the first time.

Thanks,
Myke

[shg]

Progress bars need some kind of code metric to infer how far they are along toward completion (e.g., loop counters). What feedback do you get from the Save process to support that?

I think Andy Pope has the definitive collection of progress meters -- see http://andypope.info/vba/pmeter.htm. But they don't address the first issue.

[GuitarMyke]

I think Andy Pope has the definitive collection of progress meters -- see http://andypope.info/vba/pmeter.htm. But they don't address the first issue.

As I stated before, that post didn't really help much. I am here looking for real answers to a solution and what people keep doing, especially moderators who care more how people format their posts instead of truly helping people, is putting in a links to websites that don't really help much.

So, if you don't know how to do this, that's fine, but what I need is someone who truly understands this to help me not someone who posts links that really don't help. I can find websites myself by using Google.

Sorry for being so direct, but I simply don't have time to f--- around.

Comprende? Mods?

[shg]

Wild guess, here: you're a highly-sought motivational speaker, and the huge file you're saving is a list of your clients ...

[jerryjaysr]

I have been here for a short time, but have nothing but nice things to say about everyone!!

They have been a tremendous help.

I am helping out a friend (and not getting paid). I have spend a few hundreds hrs on projects for him..just because he is my friend and he has no knowledge of Excel.

Thank you Friends here for taking the time to help me!

Sorry bro if you are having a bad day. Hang in there and ask nice....


(sorry mods for interfering)

[royUK]

GuitarMyke - solve your own problems. You have been offerd links to examples. IMO you shouldn't need a progress bar, the slowness is probably due to inefficient coding!



I am locking this post due to your attitude.