Screen update issues during code execution

[Rhudi]

I'm using Office 365 (Office 2013?). In Excel, during macro execution, I will use Application.ScreenUpdating = True/False where appropriate to speed up macro execution where applicable.

I realize the it is preferred to never ".Select" anything.

However, I like to use (Range/Row).Select to highlight a row as a "progress indicator" to help show where the macro is working.

With an earlier version of Excel, this was ok. Now, I have discovered a glitch caused by "?Animation". My macro seems to run too fast to let the screen catch up.

I will:

Please Login or Register  to view this content.

Very often, I will get blank gray areas where the range was selected, but the cell data won't show up before the screen update is turned off.
In some cases, I can "fix" this by adding a timed wait. But, why would I want to deliberately slow down my code?

Every time my code detects something that I want to show the affect cell next to my msgbox, the updating on / msgbox / updating off seems to work just fine.

I've noticed that the animated selection box can get stuck on screen when I have a 'selection change' event if I'm not careful.

Is there some kind of display sync wait?

[mehmetcik]

how about turning the screen on at certain points? Maybe every 10th row?

Or how About using the Status Bar to display the row number.

Please Login or Register  to view this content.

This works:-

Please Login or Register  to view this content.

[Rhudi]

I use Application.StatusBar to indicate the steps that I'm working within a particular row.

I'd like to be able to select a row (or range of the row) and have the highlight bar be solidly on that row, whilst the actual processing is happening (and the status bar is showing the steps in the pass for that row).

I'm contemplating creating a subroutine for the "row select".

Something like:

Please Login or Register  to view this content.

[Rhudi]

I realised another minor glitch. The previous code will hang if excel looses focus and the Excel icon on my taskbar lights up.

If I put a 'DoEvents' at the end of the sub, it works again.

I changed the above to look like this:

Please Login or Register  to view this content.

[Rhudi]

I also noticed that if there is a Form Show, it freezes no matter what (if Excel doesn't have focus).