본문 바로가기

Computer/Excel

Excel macro send key

 

 

Application.SendKeys("{UP}")

Application.SendKeys("{DOWN}")

Application.SendKeys("{LEFT}")

Application.SendKeys("{RIGHT}")

Application.SendKeys("{ENTER}")

BACKSPACE/{BACKSPACE} or {BS}
BREAK/{BREAK}
CAPS LOCK/{CAPSLOCK}
CLEAR/{CLEAR}
DELETE or DEL/{DELETE} or {DEL}
DOWN ARROW/{DOWN}
END/{END}
ENTER (numeric keypad)/{ENTER}
ENTER/~ (tilde)
ESC/{ESCAPE} or {ESC}
HELP/{HELP}
HOME/{HOME}
INS/{INSERT}
LEFT ARROW/{LEFT}
NUM LOCK/{NUMLOCK}
PAGE DOWN/{PGDN}
PAGE UP/{PGUP}
RETURN/{RETURN}
RIGHT ARROW/{RIGHT}
SCROLL LOCK/{SCROLLLOCK}
TAB/{TAB}
UP ARROW/{UP}
F1 through F15/{F1} through {F15}

 

 

https://docs.microsoft.com/en-us/office/vba/api/excel.application.sendkeys

 

'Computer > Excel' 카테고리의 다른 글

VBA 엑셀 모든 시트의 함수를 값으로 변경  (0) 2022.02.19
Excel macro - Visual Basic loop  (0) 2021.10.04