Member Avatar for 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

  • 3 Contributors
  • 2 Replies
  • 64 Views
  • 14 Hours Discussion Span
  • Latest Post Latest Post by QVeen72

Recommended Answers

All 2 Replies

Member Avatar for 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

Member Avatar for QVeen72

Hi,

Can you check removing Wait..?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.