Suggestion for the Excel Development Team

[Albert]

Hi!
I have a small issue to report:
I am a VBA Developer and when my software creates reports, I like to have
Application.ScreenUpdating = False so that the users wont see what's going on
in the sheet where the report is being created.

I also like to use the status bar to keep the user informed on the progress.

However, in Excel 2007, when I have screenupdating=false, the status bar
becomes all jumbled when I change the progress message in the status bar.
This used to work fine in Excel 2003.

Perhaps you (they?) could fit it in the next office update?

If this isn't the right forum to make this kind of request, could someone
point me in the right direction?

Thanks in advance,

Albert C.

 

[Peter T]

Try not to update the status bar more than say every 0.1 sec. In a long loop
0.5 or even 1 second is fine. Apart from making the statusbar readable it
may well help speed up your routine.

for i = 1 to bigNumber
do stuff
k = k + 1
if k > 1000 then ' adjust to suit
application.statusbar = "done " & i
k = 0
end if
next

Regards,
Peter T