98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » excel consultants - Screen Flickering
excel consultants - Screen Flickering
Resolved · Low Priority · Version Standard
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?
Mon 23 Jul 2007, 11:02Trainer Tracy said...
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
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 tip:How to apply the same formatting and data to multiple sheets at the same time in Excel 2010When you want to format more than one sheet in a worksheet exactly the same way, Ctrl-click the tabs of the sheets you want to group together and they will all turn white. While they are grouped, anything you enter in one sheet gets entered into the others. |
