Ms excel screen updating
Does anyone know what it means when you show a user form on the screen, and when you move the form around with your mouse, it leaves a trail.
It's like the screen behind is frozen from being updated. However, if the user clicks cancel while the report is printing, error #1004 occurs ("Print method...failed").
Also, if you already have your VBA editor environment open when testing this, it appears to be in break mode (because the "Run" button in the toolbar is disabled and the "Reset" button is enabled), but there is not other evidence of it being "broken". So, I trapped the error and tried to have the form with the print button on it unload, and a new form appear.
Specifically, I am trapping an error, unloading one user form and loading another. The new form appears, but the old is still on the screen (but I feel that it probably really is unloaded).
Dimensional [email protected] I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.
I've emailed instructions to Mike on how to clean up his hard drive and told him to then run the code again.
Now press the Visual Basic Command button again, and note that Excel does not paint itself correctly.- bonus question..thanks My forms are "Spec Reports" and "PIFControl Menu". Thank you for your cooperation." _ & vb Cr Lf & vb Cr Lf & "Error Number: " & Err.Number & vb Cr Lf & "Error " _ & "Description: " & Err. Repaint Unload Spec Reports Exit Sub End If When they hit the button to print, why don't you disable the Cancel button. Then, at the end of the print function, enable the buttons again.Repeat the steps again with the Command button's code modified as follows: Private Sub Command1_Click() o App. While you can certainly copy and paste data from a network or Web-based external source into Excel, importing the data by connecting to it provides an added benefit.
STATUSMicrosoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article.