Menu
| Home |
| Search |
| Today's Posts |
| Home | Search | Today's Posts |
| ExcelBanter » Excel Newsgroups » Excel Programming > SendKeys to emulate ALT+TAB, TAB, TAB |
| LinkBack | Thread Tools | Search this Thread | Display Modes |
#1  Posted to microsoft.public.excel.programming |
Edmund  external usenet poster | Posts: 62 | |
 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)  Reply With Quote |
| #2 Posted to microsoft.public.excel.programming |
| Edmund external usenet poster | Posts: 62 | |
| 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 With Quote |
| Thread Tools | Search this Thread |
 Show Printable Version | Search this Thread: Advanced Search |
| Display Modes |
 Linear Mode  Switch to Hybrid Mode  Switch to Threaded Mode |
 Posting Rules | | Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On | |
 Similar Threads |
| Thread | Thread Starter | Forum | Replies | Last Post |
| Is it possible to emulate a ten-key entry in Excel? | Garth Hales | Excel Discussion (Misc queries) | 9 | November 28th 06 12:55 PM |
| How do u emulate nesting seven IF functions in a cell? | Arpee Ong | Excel Worksheet Functions | 2 | February 9th 06 07:30 AM |
| How do I emulate rightclick on a hyperlink in an Excel Macro | Emulate RightClick on Hyperlink in Macro | Excel Discussion (Misc queries) | 0 | January 2nd 06 09:40 AM |
| Emulate C/C++ struct in VBA? | No Name | Excel Programming | 8 | January 8th 04 09:24 PM |
| How can I emulate MROUND in VBA | Jay Fincannon | Excel Programming | 1 | August 8th 03 04:39 AM |
All times are GMT +1. The time now is
06:36 PM. Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter. The comments are property of their posters. About Us
"It's about Microsoft Excel"
- Search
- Home
- Contact Us
- Today's Posts
- Register Now
- FAQ
Contact Us ExcelBanter forum home Privacy Statement | LinkBack |
 LinkBack URL |
 About LinkBacks |
