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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |