ExcelBanter - (keys,wait) excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - (keys,wait) excel (https://www.excelbanter.com/excel-discussion-misc-queries/220340-keys-wait-excel.html)

(keys,wait) excel

How do I use the "Wait" in Application.sendkeys(keys,wait)
Example - Application.sendkeys("123456789",wait)
I need Excel to allow the keystrokes to be entered before the macro continues
--
MM

Jim Thomlinson

(keys,wait) excel

With Application
..SendKeys "123"
..Wait Now + TimeSerial(0, 0, 2)
End With
--
HTH...

Jim Thomlinson

"MM" wrote:

How do I use the "Wait" in Application.sendkeys(keys,wait)
Example - Application.sendkeys("123456789",wait)
I need Excel to allow the keystrokes to be entered before the macro continues
--
MM

All times are GMT +1. The time now is 02:36 PM.