Vb net screen updating
You can increase the speed of some procedures by keeping screen updating turned off.I have a program written in VB 2010 express under windows xp which does some heavy number crunching combined with serial communication. Not sure if this is possible in VBA, but the general approach is to use additional thread for any CPU/memory/network heavy operations.An approach to take in these types of situation is to start a new thread with computation intensive (or potentially blocking operation such as I/O) processing in a separate thread, allowing the GUI to stay alive on the main thread.
To prevent this create a class called Freeze and use it in your form like this: Dim Freeze as New Freeze Freeze.
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.
EXE process.) How much of a difference does invisibility make?
Then comment out the line which turns off screen updating and see what happens; you should find that you scroll down the sheet as the numbers get filled.
Screen Updating = True Try running it and you should see a short pause followed by column A getting filled with numbers.