Application.ScreenUpdating = False still causing screen to flash...

[Shaka215]

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 Peltier]

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

- Jon

 

[Shaka215]

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]

Is it a modal or nonmodal form? Why use sendkey-tab when you can use
Activecell.Offset(,1).Select?

- Jon

 

[NickHK]

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