| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible to emulate a ten-key entry in Excel? | Excel Discussion (Misc queries) | |||
| How do u emulate nesting seven IF functions in a cell? | Excel Worksheet Functions | |||
| How do I emulate rightclick on a hyperlink in an Excel Macro | Excel Discussion (Misc queries) | |||
| Emulate C/C++ struct in VBA? | Excel Programming | |||
| How can I emulate MROUND in VBA | Excel Programming | |||
Linear Mode
