There is an good example in Tricktresor or com Forum by Stephan Schnell.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.Many times the macro may do quite a bit with the data, such as selecting different cells, replacing values or formulas, and taking other types of actions.This means that the Excel screen can look like it has "gone crazy" while the macro is running.Hello, The beginning of t he code I am writing turns off screen updating, but the screen still updates as the code runs. Many people write their own macros to manipulate the information in a workbook.Beside of this you can use an SAP Scripting code to read all lines from ALV list into Excel.You will find a log of examples via Google about this.
The first time the example hides the columns, screen updating is turned on; the second time, screen updating is turned off. Hidden = True End If Next c stop Time = Time elapsed Time(i) = (stop Time - start Time) * 24 * 60 * 60 Next i Application.
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.
A User Form will not be refreshed in some cases, because Do Events will fire the events; however, Repaint will update the User Form and the user will see the changes on the screen even when another event immediately follows the previous event.
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.