Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » excel consultants - Screen Flickering
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
excel consultants - Screen Flickering
Resolved · Low Priority · Version Standard
Reply Thu 19 Jul 2007, 09:58Delegate Steven said...
Steven has attended:
Excel VBA Intro Intermediate course
Screen Flickering
How do you stop the screen flickering?
For upcoming training course dates see: Pricing & availability
RE: Screen Flickering
Hi Steven,
Thank you for the posting
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 at the beginning of the procedure:
Application.ScreenUpdating = False
The screen comes on automatically on completion of the program. If you require screen updating to resume before the end type
Application.ScreenUpdating = True
Tracy
|