Screen updating macro

If this does happen, you may need to repeat the line: Application.This is part 2 of the Macro Efficiency series where in we teach you how to code efficiently using Microsoft Excel VBA.This method which we are going to discuss today is recognized as one of the basic and the most important method for making the code efficient.

Excel & Word have the Screen Updating method thru which a developer can lock the main window from unnecessarily redrawing itself whilst the macro is being executed. If left alone, redrawing is not only ugly on the eyes it also takes more time for the macro to reach completion.

It is not required to turn on screen updating after writing of code is over as it would by default automatically gets turned on.

But just in case if you want to display a message to a user saying " the command is executed" or want to display a userform etc.

It will automatically turn onwhen the macro is finished.

Sometimes you want to turn on the screen updating afteryou have turned it off, e.g.

Leave a Reply

  1. Online webcam sex chat with girls face to face for free 03-May-2020 02:10

    Is there any way to force the validation of all controls when the user click on OK?

  2. Chat with f sex slave 05-Jul-2020 01:48

    As emails are an unsecured means of communication, there is a risk your email could be viewed by others if it is intercepted or sent to an incorrect address, and Bankwest assumes no responsibility for this.