SendKey Method Not Respoding . .

[Evagrius Ponticus]

Hi, I am not sure why this isn't working . . I can't see anything wrong with the code . . .thanks

Private Sub CommandButton2_Click()
    SendKeys "%EG"
    SendKeys "%s"

End Sub

 

[Norie]

What's the purpose of the code?

 

[Evagrius Ponticus]

Hi Norie . . I have a userform with several buttons. The one in question is supped to duplicate ALT+E > G > ALT s. This will as I am sure you know bring up the "Go To" dialog box . . .

 

[Norie]

You really should avoid using SendKeys, because as you've found out it's unreliable.

And the only way I can seem to get your code to work is if the form is non-modal.

But I'll ask again, what's the purpose of the code?

 

[Evagrius Ponticus]

Well, Norie, I fear there is no official purpose other than learning. I am teaching myself how to use the SendKey Method just for the sake of learning. I had it vbmodal but I changed to vbmodeless and it works . . hmmm - that's good to know.

You'll laugh once I tell you this, but for a minute I thought it had something to do with my wireless keyboard