Mimick MS Progress Indicator?

[JK]

For visual effect during a long macro, I would show an "animated" progress
indicator similar to the one used by MS. Not to track progress, just a
series of looping green tiles for the user to look at during the macro.

Does anyone know how to write, or where I can obtain? Thank you.

Jim Kobzeff

 

[JulieD]

Hi Jim

John Walkenbach has a couple of approaches in his book "Power Programming
with Excel 200x" ... the book is definitely worth getting hold of if you
don't already have it. He also has an article on his website on how to do
it http://j-walk.com/ss/excel/tips/tip34.htm - Displaying a Progress
Indicator

Cheers
JulieD

 

[JK]

Thank you, Judy

Yes, I have the book. But John's progress indicator is not exactly what I'm
looking for.

Regards

 

[JulieD]

Hi

you mean a userform with an animated graphic on it ... ? nothing to do with
progress at all?

JulieD

 

[Andy Pope]

Hi Jim,

I have a few alternatives here.
http://www.andypope.info/vba/pmeter.htm

If you wanted to create something like the Delete progress then you will
need a set of images laid out on the userform. Then where the code
normally extends the progress bar you will need to change the visibilty
of the images to mimic the animation.

Cheers
Andy

 

[Rob Bovey]

It sounds like he's looking for something more like this:

http://www.appspro.com/downloads/ProgressBarClass.zip

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *

 

[JK]

Thank you all. Rob, excellent procedure. However, still not what I have in
mind. If you'll bear with me (I don't blame you if you won't), what I'm
refering to appears to be a MsgBox with a Frame and one colored Label (they
use light green) that loops from from left to right every second or so while
a procedure is running. MS uses it, not like it does a progress indicator,
but more like a visual affect simply to assure the user that something is
running.

Regards...Jim Kobzeff

It sounds like he's looking for something more like this:

http://www.appspro.com/downloads/ProgressBarClass.zip

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *

Hi Jim,

I have a few alternatives here.
http://www.andypope.info/vba/pmeter.htm

If you wanted to create something like the Delete progress then you will
need a set of images laid out on the userform. Then where the code
normally extends the progress bar you will need to change the visibilty
of the images to mimic the animation.

Cheers
Andy

what

I'm

to

 

[Rob Bovey]

HI Jim,

It looks to me like the original example you were pointed to at:

http://j-walk.com/ss/excel/tips/tip34.htm

could easily be modified to do what you're asking.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *

Thank you all. Rob, excellent procedure. However, still not what I have in
mind. If you'll bear with me (I don't blame you if you won't), what I'm
refering to appears to be a MsgBox with a Frame and one colored Label (they
use light green) that loops from from left to right every second or so while
a procedure is running. MS uses it, not like it does a progress indicator,
but more like a visual affect simply to assure the user that something is
running.

Regards...Jim Kobzeff

It sounds like he's looking for something more like this:

http://www.appspro.com/downloads/ProgressBarClass.zip

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


what to

just