Recent Addins ADO Application Arrays Charts Commandbars Count Dates Dialogs Events File access Files & Folders Functions Games Help Import & Export Lookup Off topic Other Outlook PivotTables Power Query Printing Problem solving Read me Searching Sorting Sound Strings Sum Time VBA programming VBE Workbooks Worksheets

Control the screen updating

 1999-07-23    Application    0    171

By turning off the screen updating your macros will run much faster. It will also prevent the disturbing flickering of screen pictures that can frighten inexperienced users. The following line will turn off the screen updating:

Application.Screenupdating = False
You should turn on screen updating again before your macro finishes, not all applications will successfully turn on screen updating again automatically.
Sometimes you want to turn on the screen updating after you have turned it off, e.g. when you want to display a dialog or a message box to the user.
The following line will turn on the screen updating:

Application.Screenupdating = True