Multiple SendKeys

[thedante]

Hi All,

I am new with the send keys in VBA. Basically I'd like to send a bunch of sendkeys. I don't have problem with the synthax but the problem is that excel only execute the 1st sendkeys I have written.

Sub test()
SendKeys ("^+F")
Wait
SendKeys ("^+L")
End Sub

i.e it only types Ctrl Shif F but not Ctrl Shift L there after/

Could you please help me?

Much appreciated.

Thanks

[vb5prgrmr]

Well I do not see where you have the procedure Wait defined but it should be a doevents/sleep loop that is long enough to allow the first operation from the sendkeys to execute before the second sendkeys is sent...

Good Luck

[QVeen72]

Hi,

Can you check removing Wait..?