We all use VBA macro to automate reports and for that we are very much dependent on Google. Google provides lot of information but at times it’s difficult to locate the right piece of information. This blog is created to share some useful VBA codes which can be used by professionals in their work. You will find ready to use codes and formulas to make your job easy.
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}
Some useful SendKeys in VBA:
ReplyDeleteBACKSPACE = {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}