Vba excel screenupdating not working

27-Feb-2016 15:00

You can find a version of this tip for the older menu interface of Excel here: Turning Off Screen Updating. Automate virtually any routine task and save yourself hours, days, maybe even weeks.Then, learn how to make Excel do things you thought were simply impossible! Status Bar text can be updated with anything throughout the macro - plain text, calculated completion precentages, elapsed time, etc.Mastering advanced Excel macros has never been easier. A simple and less involved method of providing progress updates would be to use the following line of code in the macro: Application. Prior to "End Sub", place this last line of code: Application. Screen Updating = False, the statusbar will change.] This does the side effect that it looks as though Excel has "hung" or crashed, especially if the macros is going to take some time to execute.The idea is to use the first line near the beginning of your macro, and then use the second line near the end.

Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, and 2013.If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you.Many times the macro may do quite a bit with the data, such as selecting different cells, replacing values or formulas, and taking other types of actions.This means that the Excel screen can look like it has "gone crazy" while the macro is running.One thing you may want to do with your macro to make it run faster and to prevent distracting flashes on the screen is to turn off screen updating while the macro is running.

Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, and 2013.

If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you.

Many times the macro may do quite a bit with the data, such as selecting different cells, replacing values or formulas, and taking other types of actions.

This means that the Excel screen can look like it has "gone crazy" while the macro is running.

One thing you may want to do with your macro to make it run faster and to prevent distracting flashes on the screen is to turn off screen updating while the macro is running.

The following macro lines will, respectively, turn off screen updating and then turn it back on in a VBA macro.