Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 'VBA keystroke commands
- 'I post all of my code for free and am not seeking any financial compensation. If you're
- 'compelled to be generous or find this helpful, please consider a tax deductible
- 'donation to Reason Magazine: https://reason.com/donatenow/donate.php
- 'Share a screenshot with me of your donation, even if just a few bucks.
- 'It inspires me to post more of these. My username is PGCodeRider on most social media.
- 'all below syntax options leverage the application.sendkeys command.
- 'So if you wanted to simulate the keystroke of UP and then DOWN here is the code:
- Application.SendKeys ("{UP}")
- Application.SendKeys ("{DOWN}")
- '-------
- BACKSPACE {BACKSPACE}, {BS}, or {BKSP}
- BREAK {BREAK}
- CAPS LOCK {CAPSLOCK}
- DEL or DELETE {DELETE} or {DEL}
- DOWN ARROW {DOWN}
- END {END}
- ENTER {ENTER}or ~
- ESC {ESC}
- HELP {HELP}
- HOME {HOME}
- INS or INSERT {INSERT} or {INS}
- LEFT ARROW {LEFT}
- NUM LOCK {NUMLOCK}
- PAGE DOWN {PGDN}
- PAGE UP {PGUP}
- PRINT SCREEN {PRTSC} (reserved for future use)
- RIGHT ARROW {RIGHT}
- SCROLL LOCK {SCROLLLOCK}
- TAB {TAB}
- UP ARROW {UP}
- F1 {F1}
- F2 {F2}
- F3 {F3}
- F4 {F4}
- F5 {F5}
- F6 {F6}
- F7 {F7}
- F8 {F8}
- F9 {F9}
- F10 {F10}
- F11 {F11}
- F12 {F12}
- F13 {F13}
- F14 {F14}
- F15 {F15}
- F16 {F16}
- Keypad add {ADD}
- Keypad subtract {SUBTRACT}
- Keypad multiply {MULTIPLY}
- Keypad divide {DIVIDE}
Add Comment
Please, Sign In to add comment