Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application.ScreenUpdating = False still causing screen to flash...
Hello! I have seemed to come across something rather annoying when it
comes to using the following code... Private Sub CommandButton26_Click() '---- ENTER KEY Application.ScreenUpdating = False Unload Me SendKeys "{Enter}", True keyboard.Show End Sub The problem is when I have the form unloads and reloads it causes the buttons on the user form to flash quickly...This can be used in its condition however I would like to know if its possible to prevent the user form from flashing when it reloads...since its not neccessary for the end-user to see this graphical error. You would think with the logic of "ScreenUpdating = False" VB would make it seem like the user form never disappeared...anyone have any ideas on making this form not flash when it reloads? It's annoying and looks like amature hour with a computer. Any help is much appreciated!!! Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to set Application.ScreenUpdating = False for Gen use | Excel Discussion (Misc queries) | |||
Using the Application.ScreenUpdating = False? | Excel Programming | |||
Using the Application.ScreenUpdating = False? | Excel Programming | |||
Application.screenUpdating = False | Excel Programming | |||
Application.ScreenUpdating = False | Excel Programming |