Hello !
Here's my problem :
With those 4 lines of code, i want to simulate the Shift+Pause combination, and it works.
Please Login or Register to view this content.
But the problem is, after that, the Shift key is still press, and it causes me a lot of trouble.
I tried SendKeys, but they didn't work for that combination of keys.
Thank you.
A.
PS : I had the same problem with a Ctrl + V, with the Ctrl Key.
Welcome to the forums. What is it that you are trying to accomplish because instead of the pause you might be able to tell the macro to wait for a specific amount of time long enough for you to do something and then it will continue rather than you having to pause it. Also if you are having trouble because you don't have a break key try this. If that is too annoying or to long again you can tell the macro to wait. Let me know.
http://social.msdn.microsoft.com/For...terrupting-vba
"CTRL-BREAK does work on Windows 7 and Windows 8 and on all versions of Excel including 2013. However, if you don't have "DoEvents" in your loop it will not work, since the break signal is never processed.For all loops, put a "DoEvents" in your loop. Also, save your work before running new code! BTW, for a computer without a BREAK key, press the start button, type "On" and choose "On-Screen Keyboard". When the keyboard appears you can click CTRL then click "PAUSE" (which is the same as BREAK).
Saturday, August 17, 2013 9:39 PM
BY: "ChaosFreak"
"
Thank those who have helped you by clicking the Star * below their name and please mark your post [SOLVED] if it has been answered satisfactorily.
Did this help?
Hello little75,
From the symptoms you describe, I suspect that your constant KEYEVENTF_KEYUP is not equal to 2. Did you declare the constant locally within the procedure or globally in a VBA Module?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks