If I type in my name and my e-mail and, "Again, more cinnamon," and click Add Suggestion, which runs the macro that copies this data back to Sheet3, you see that you got screen flicker.Now the macro worked correctly, but again the user experience isn't all it could be.

excel turn off screen updating-50

Excel runs its macros extremely quickly, especially on contemporary computers that have multiple processors and gigabytes of memory.

When an Excel VBA routine changes from one worksheet to another at high speed, you get screen flash.

It's not a big deal while you are testing your code, in fact it lets you know your macros working, but it does degrade the user experience.

Let me show you what happens when I have a macro that has, in this case a bunch of unnecessary switches from worksheet to worksheet, but I wanted to show you what screen flicker looks like.

My Excel tool performs a long task, and I'm trying to be kind to the user by providing a progress report in the status bar, or in some cell in the sheet, as shown below.

But the screen doesn't refresh, or stops refreshing at some point (e.g. The task eventually completes but the progress bar is useless. For i=1 to imax ' imax is usually 30 or so fraction Done=cdbl(i)/cdbl(imax) Application.

Status Bar = Format(fraction Done, "0%") & "done..." ' or, alternatively: ' status Range.value = Format(fraction Done, "0%") & "done..." ' Some code.......

Next i Sub Progress Meter() Dim boo Status Bar State As Boolean Dim i Max As Integer Dim i As Integer i Max = 10000 Application.

Screen Updating = False ''//Turn off screen updating boo Status Bar State = Application.

Display Status Bar ''//Get the statusbar display setting Application.

Display Status Bar = True ''//Make sure that the statusbar is visible For i = 1 To i Max ''// imax is usually 30 or so fraction Done = CDbl(i) / CDbl(i Max) Application.