Ms excel screen updating


Screen Updating = False ''//Turn off screen updating boo Status Bar State = Application.Display Status Bar ''//Get the statusbar display setting Application.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.How can you turn off the flashing screen during macro execution ?Display Status Bar = True ''//Make sure that the statusbar is visible For i = 1 To i Max ''// imax is usually 30 or so fraction Done = CDbl(i) / CDbl(i Max) Application.

But the screen doesn't refresh, or stops refreshing at some point (e.g. The task eventually completes but the progress bar is useless. For i=1 to imax ' imax is usually 30 or so fraction Done=cdbl(i)/cdbl(imax) Application.You might encounter an issue with Do Events if you are using event triggers in your form.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.It's just an idea for you to try, and its effectiveness is pretty dependent on your sheet and calculations.Specifically, if you are dealing with a User Form, then you might try the Repaint method.I can do all of this apart form the last bit where I access the report and write the data onto the reports controls. (just a personal joke there) I have as much knowledge of Access as the huns have of European football after Christmas.

You must have an account to comment. Please register or login here!