ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   SendKeys to emulate ALT+TAB, TAB, TAB (https://www.excelbanter.com/excel-programming/375022-sendkeys-emulate-alt-tab-tab-tab.html)

Edmund

SendKeys to emulate ALT+TAB, TAB, TAB
 
How can I use VBA Sendkeys Method to achieve the below?

Using the keyboard, while holding down ALT key, I need to press TAB for 3
times in order to toggle to the 4th Window.

All below attempts failed, even if I add Application.Wait on the next line:
Application.SendKeys ("%{TAB}{TAB}{TAB}"), True
Application.SendKeys ("%{TAB}{TAB}{TAB}"), False
Application.SendKeys ("%{TAB}%{TAB}%{TAB}"), True
Application.SendKeys ("%{TAB}%{TAB}%{TAB}"), False

Thanks alot

--
Edmund
(Using Excel XP)

Edmund

SendKeys to emulate ALT+TAB, TAB, TAB
 
Sorry guys. I got it with "Application.SendKeys ("%{TAB 3}"), True"
It seems like F1 Help did better than my 2 reference books.

--
Edmund
(Using Excel XP)




All times are GMT +1. The time now is 05:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com