R
Robert Flanagan
I have some code that updates the statusbar with the row number being
processed. Sometimes this update freezes but the code keeps running. Is
there a way to force the statusbar to update all the time?
For example
For r = 1 to 60000
application.statusbar "processing row " & r
next
will freeze. I've tried doing it every 10, 20, 100 rows and it will still
freeze. I can do a ctl-break and resume, but I don't want users to do that
obviously.
processed. Sometimes this update freezes but the code keeps running. Is
there a way to force the statusbar to update all the time?
For example
For r = 1 to 60000
application.statusbar "processing row " & r
next
will freeze. I've tried doing it every 10, 20, 100 rows and it will still
freeze. I can do a ctl-break and resume, but I don't want users to do that
obviously.