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
_______


<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
> _______
>
>
> <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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!
> >

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

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


<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>> _______
>>
>>
>> <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>> > 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

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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!
>