VBA – Turn off Screen Updating

Associated Files Download Links

As cool as it looks watching your macro manipulate the screen, you can help it run faster if you turn off Screen Updating.

Disable Screen Updating

1. At the beginning of your code put this line:

Enable Screen Updating

2. At the end of your code put this line:

VBA Coding Made Easy

Stop searching for VBA code online. Learn more about AutoMacro – A VBA Code Builder that allows beginners to code procedures from scratch with minimal coding knowledge and with many time-saving features for all users!

VBA Turn Off On ScreenUpdating

<<Return to VBA Examples

Did you find this VBA tutorial useful? Then share it with your friends and colleagues: