Stoping Screen Flicker when Macro Runs?

[Mark]

I have a form with a large number of checkboxes. The
macro I have created checks to see which check boxes are
checked and then adds a certain number to a variable
which it displays as a score at the end of the document.
The problem is that when the macro is launched (from a
command button) the screen and hourglass flicker rapidly
for 5 seconds before the results are displayed. I can
understand the time lag du to the large number of if
statements, but is there a way to have it just display
the hourglass without all of the flickering? Perhaps
something to tell it not to update the screen until the
macro has finished? Thanks in advance.

 

[Jonathan West]

Hi mark

Application.ScreenUpdating = False

Also, if you macro is using the Selection object at all, get it to use a
Range variable instead if at all possible.

 

[Rick Stebbins]

Hi Mark,

Use this command to turn off screen updating. Just make
sure to turn ScreenUpdating on again, whether your macro
finishes normally or through its error handler.

Word.Application.ScreenUpdating = False

Rick