Screen updating false
When screen updating is turned off, toolbars remain visible and Word still allows the procedure to display or retrieve information using status bar prompts, input boxes, dialog boxes, and message boxes.
You can increase the speed of some procedures by keeping screen updating turned off. Insert Paragraph After End With If x Mod 50 = 0 Then Active Document.
The screen will show no updates until the entire list is finished. This prevents you from interacting with Excel until the User Form is closed. The problem is that no matter how many times I turn screen updating on and off, the fact that the cells have been updated don't show up until all the code is finished processing.
What way can I force the screen to refresh the user view? It doesn't even work when screen updating is turned on all the time. Hello dcanham, It is difficult to provide a solution in the absence of code controlling the check boxes. Set the Show Modal property in the Properties window to False. Since there seems to be questions about the code chunk I posted it here and bolded the spot where it isn't working.
You will have to test this and loet me know if any errors occur and the line they occur on.You must set the Screen Updating property to True when the procedure finishes or when it stops after an error. This example turns off screen updating and then adds a new document. Both suggestions assume you are using individual check boxes and not check boxes that appear in a List Box control. It just changes the color, border, and removes diagonal lines. I made it a subroutine because it can be called from several different places.
If you are not using a User Form then try inserting Do Events in your code after you change the state of the check box. The process is as follows: What I would like it to do is during the execution of the code, as it finishes each cell, it turns off the formatting on the cell.