PROGRESS INDICATOR

[jason]

Does anybody have any code for a good progress indicator, at the
moment I'm just using:

With Application
.ScreenUpdating = False
.StatusBar = "Please wait .................. macro running
........"
End With

This is a bit basic and doesn't give any indication of how far through
the PC is.

Any help,or links, greatly appreciated.

J

 

[merjet]

Does anybody have any code for a good progress indicator?

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

In the VB Editor try right-clicking the Toolbox. You should
get a list of additional controls including Microsoft Progress
Bar x.0.

HTH,
Merjet

 

[Andy Pope]

Hi Jason,

The may give you some food for thought.
(http://www.andypope.info/vba/pmeter.htm)

Does anybody have any code for a good progress indicator, at the
moment I'm just using:

With Application
.ScreenUpdating = False
.StatusBar = "Please wait .................. macro running
......."
End With

This is a bit basic and doesn't give any indication of how far through
the PC is.

Any help,or links, greatly appreciated.

J

--

Cheers
Andy

http://www.andypope.info

 

[Robin Hammond]

There's a downloadable class and demo here that writes to the status bar in
97 or displays a progress indicator in 2000 and above and an ability to
handle a cancel button.

http://www.enhanceddatasystems.com/ED/Pages/ExcelProgressBar.htm

Robin Hammond
www.enhanceddatasystems.com
Check out our XspandXL add-in

 

[Joe 90]

I have tried most of the progress bars available, and whilst they are all
excellent, they never seem to work with "my code" of "your code here"
This is because it seems that most of the progress bars rely on "my code"
being quite simple, and running a loop or similar. When "my code" is more
complex, the progress bars do not seem to work. Any way around this?

Joe

 

[J.E. McGimpsey]

First, how are you measuring progress? The solution you want will
depend almost entirely on what drives the indicator. On many
applications, as you say, it's a loop, but if not, what metric are
you using?

I'm sure you know how your code works, but the rest of us don't know
what "more complex" means to you...

Also, using phrases like "do not seem to work" provide nearly no
useful information. What isn't working? What do you expect to see
that you're not seeing (or see that you don't expect)? Is there a
crash? Inaccurate data? No response? etc. Or can you not figure out
how to adapt the code for your application.

 

[Robin Hammond]

Joe,

all I can say is that I have some extremely complex code running around my
thing all the time and it works for me. Furthermore, since I have this thing
publicly available on my site, if there is a bug you have found, please let
me know privately and I'll fix it.

If you are using mine and not seeing updates to the progress indicator, try
adding another DoEvents statement after a .progress command in the
controlling routine. Although the class issues the DoEvents command itself,
I have seen instances where the system still gets left behind.

Robin Hammond
www.enhanceddatasystems.com
Check out our XspandXL add-in