MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Sending Shift + right arrow


Posted by Joe C on August 13, 2001 8:06 AM

Does anyone know how to send the shift key + the right arrow key to another application.
Ive used the send key but I do not know how to emulate the shift right arrow or how to keep Shift active.
Thanks for any help.


Posted by Jerid on August 13, 2001 8:28 AM

Joe, this will do it.

Application.SendKeys "+{RIGHT}", True

Jerid

Posted by Joe C on August 13, 2001 9:03 AM

Thanks so much. IT works great.
After I have highlighted area, How would I copy to clipboard from VBA in another application?