VBA query

  Chas49 15:42 09 Apr 10
Locked

Is it possible to use the Sendkeys instruction in VBA Office 2007 when running Win 7. I have not , so far, been able to do this. Is the instruction still valid?

  VoG II 16:16 09 Apr 10

Yes it is. With Excel 2007 running under Windows 7


Sub test()
SendKeys "{F1}"
DoEvents
End Sub


launches Help.

  VoG II 16:17 09 Apr 10

By the way, SendKeys is notoriously flaky.

  Chas49 16:24 09 Apr 10

As usual VoG™ you've saved the day! I was forgetting the DoEvents instruction! Where would be without the likes of you - up the creek!!

Many thanks.

This thread is now locked and can not be replied to.

The Legend of Zelda Breath of the Wild review: Five hours with Zelda on the Nintendo Switch

1995-2015: How technology has changed the world in 20 years

How the painting-like animated sequences in A Monster Calls were created by Glassworks Barcelona

The 22 best Safari extensions | Best Safari plugins: Improve Apple's Safari web browser with these…