|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 4th, 2006, 05:57 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
SendKeys syntax problem
Can anyone please help. I am performing a search, that part of the code is working fine. When my result cell is activated, I would like to select both it, and the cell to the immediate right of it. I've tried using SendKeys, but I'm having difficulties with the syntax obviously. Code: -------------------- Application.SendKeys +("{RIGHT}") -------------------- I'm using the "plus"sign "+" for the SHIFT key to hold and select, but I'm obviously writing the {RIGHT} portion of the code incorrectly, as I get a run time error. Any assitance would be much appreciated. This is driving me nuts. Thanx in Advance. -- VBAvirgin ------------------------------------------------------------------------ VBAvirgin's Profile: http://www.excelforum.com/member.php...o&userid=16327 View this thread: http://www.excelforum.com/showthread...hreadid=497814 
|
|
#2
January 4th, 2006, 10:48 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
SendKeys syntax problem
Maybe try
application.sendkeys ("+{RIGHT}") -- HTH Bob Phillips (remove nothere from email address if mailing direct) "VBAvirgin" wrote in message ... Can anyone please help. I am performing a search, that part of the code is working fine. When my result cell is activated, I would like to select both it, and the cell to the immediate right of it. I've tried using SendKeys, but I'm having difficulties with the syntax obviously. Code: -------------------- Application.SendKeys +("{RIGHT}") -------------------- I'm using the "plus"sign "+" for the SHIFT key to hold and select, but I'm obviously writing the {RIGHT} portion of the code incorrectly, as I get a run time error. Any assitance would be much appreciated. This is driving me nuts. Thanx in Advance. -- VBAvirgin ------------------------------------------------------------------------ VBAvirgin's Profile: http://www.excelforum.com/member.php...o&userid=16327 View this thread: http://www.excelforum.com/showthread...hreadid=497814
|
|
#3
January 4th, 2006, 04:42 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
SendKeys syntax problem
Thank You Bob for your quick & helpful response. I knew it was just a what goes where thing that was bogging me down. Thanx again my friend.  -- VBAvirgin ------------------------------------------------------------------------ VBAvirgin's Profile: http://www.excelforum.com/member.php...o&userid=16327 View this thread: http://www.excelforum.com/showthread...hreadid=497814
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Relationship Problem | JNariss | New Users | 4 | December 14th, 2005 08:46 PM |
| DLookup Syntax Problem | jim_9296 | General Discussion | 1 | December 6th, 2005 04:23 PM |
| Outlook 2003 *Not Responding* ongoing problem, no solutions | RedHeadedMenace | General Discussion | 0 | December 2nd, 2005 07:31 PM |
| Fixing my embedded objects problem | JMF | General Discussions | 2 | December 2nd, 2005 07:47 AM |
| Productkey problem when installing office 2003 on network | Stefan Schreurs | Setup, Installing & Configuration | 1 | June 1st, 2004 11:16 PM |
Linear Mode
