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


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

"Robin Hammond" wrote in message
...
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/E...rogressBar.htm

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


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