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

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" wrote in message
...
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

Thank you, Judy

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

Regards

"JulieD" wrote in message
...
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" wrote in message
...
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

Hi

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

JulieD

"JK" wrote in message
...
Thank you, Judy

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

Regards

"JulieD" wrote in message
...
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" wrote in message
...
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

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

JK wrote:
Thank you, Judy

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

Regards

"JulieD" wrote in message
...

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" wrote in message
. ..

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







--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

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 *


"Andy Pope" wrote in message
...
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

JK wrote:
Thank you, Judy

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

Regards

"JulieD" wrote in message
...

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" wrote in message
. ..

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







--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

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

"Rob Bovey" wrote in message
...

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 *


"Andy Pope" wrote in message
...
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

JK wrote:
Thank you, Judy

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

Regards

"JulieD" wrote in message
...

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" wrote in message
. ..

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







--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

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 *


"JK" wrote in message
...
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

"Rob Bovey" wrote in message
...

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 *


"Andy Pope" wrote in message
...
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

JK wrote:
Thank you, Judy

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

Regards

"JulieD" wrote in message
...

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" wrote in message
. ..

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







--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info