This will help you to write Optimized VBA Code to fasten your code and build better VBA Macro Applications. Enable Events = False 'Do your Task 'changing combo box combo1.Value = " VBA Tutorials" 'Make sure that you are enabling the events once you are done with your task Application.Quick Jump Introduction | Example | Tutorial | Applications | Comments Prevent your screen from updating until your Excel macro is finished with Application. It can be used for other applications, but I find it most useful for Excel. Screen Updating property is useful when running macros that jump from cell to cell, sheet to sheet, and workbook to workbook. Screen Updating to False stops your screen from flickering (refreshing) as your macro runs.in Line 2 to see what happens when you don’t disable screen updating.Your screen will show each action your VBA code performs. It’s a good practice to disable screen updating to decrease total run time. Seek View = wd Seek Current Page Header But I can't think of a better way to get into the header. This can mean that what should take a matter of 1 to 3 seconds, often takes a lot longer.
Here are the example codes to control the Events, Screen Updating, Progress Bar, Display Alerts and other Application Objects.
The reason it speeds up code is because Excel no longer needs to repaint the screen whenever it encounters such commands as Select, Activate, Large Scroll, Small Scroll and many others. Screen Updating=False should be placed at the Start of your macro like shown below Note how we have set the Screen Updating back to True on completion.
While Excel will set this back to True whenever focus is passed back to Excel (your macro finishes) in most cases, it pays to play it safe and include the code at the end.
Screen Updating) are returning an error: Application.
Screen Updating = True THe error is Compile error, Method or data member not found Anyone has a clue what the problem is?