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!

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!

Jon,

The code to SENDKEY "{TAB}" will not work within the spreadsheet unless
the form is closed...if the form remains open Excel will TAB inside of
the user form which is not the desired result. I don't know any code I
can use to have the form be hidden (infact using FORMNAME.HIDE) doesn't
do anything to the effect...there probally isn't anything I can do but
I figured it would be worth a try...


Jon Peltier wrote:
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!

I would expect some flash, as it is the Application (Excel) that is not
updating, but the userform (VBA) is unloaded/loaded.
Do you really need SENDKEYS {TAB} to manipulate Excel ?
What about:
Activecell.Offset(0,1).select

NickHK

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!