For instance, any keys pressed while a function is running will be sent by Do Events The keyboard input will be processed before the screen is updated, so if you are changing cells on a spreadsheet by holding down one of the arrow keys on the keyboard, then the cell change event will keep firing before the main function finishes.
My Excel tool performs a long task, and I'm trying to be kind to the user by providing a progress report in the status bar, or in some cell in the sheet, as shown below.
Specifically, if you are dealing with a User Form, then you might try the Repaint method.
You might encounter an issue with Do Events if you are using event triggers in your form.
I also tried switching on and off application.screenupdating, but that seemed to slow things down enormously.
Dear Readers, In this article we are going to learn how to send an email automatically by Excel Excel VBA.