Do you have to reload the form? Can you simply change it back to its
original state?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


wrote in message
ps.com...
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!