View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Edmund Edmund is offline
external usenet poster
 
Posts: 62
Default 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)