Vb application screenupdating

by  |  14-May-2018 09:53

vb application screenupdating-2vb application screenupdating-43vb application screenupdating-57

In the above code, you could omit the lines that create and use the Word.

Application object and replace them with invisibility lines: Notice that you want to put the Word. Visible = True line in an error-handler or in a spot where you know it will be run if something goes awry. (If you do get stuck with an invisible Word in the middle of a crash, you can launch the Task Manager and kill the WINWORD.

This means that the Excel screen can look like it has "gone crazy" while the macro is running.

One thing you may want to do with your macro to make it run faster and to prevent distracting flashes on the screen is to turn off screen updating while the macro is running.

It is typically 5 to 10 times quicker (don’t catch me here it depends on what you really do) than VBA.

Community Discussion