Bookmark page
Printable version
Course updates
|
RSS feeds
Hints and tips home » VBA hints and tips » Stop Screen Flickering When Running Code
Stop Screen Flickering When Running Code
Running VBA code may cause the screen to flicker as the monitor is the slowest part of the program and cannot keep up with the very fast changes taking place.
To switch off the screen until the program is run enter the following code line:
Application.ScreenUpdating = False
The screen comes on automatically on completion of the program.
Added by Carlos on 1st December 2006
More VBA hints and tips, like:
 |
Get Sorted With PowerPoint's Best Organisational Tool Yet For anyone who works with large volumes of images and has to be organised when it comes to presentations, PowerPoint 2010 offers a comprehensive system for organising your slide content into logical groups. Now, thanks to Sections, slides can be sorted and stored by topic, author, or product. » Article: Powerpoint training london |
» Forum post: Macro recording |
» Tip: Automatically close a form |
I want to use a macro to copy data down to fill in all the blank cells in the column below the data until there is a cell with data in in and then move down to the cell with data in it to copy the procedure. 
To make a form close automatically after a certain time period, you need to assign the close function to a macro.
