Find below the list of visual basic (VB) constants associated with Keycode. These can be used anywhere in the VBA code in Excel and it is also used with Userform and other controls. It is for example a parameter of the KeyDown and KeyUp event procedures of the UserForm and its controls. Read more about that in this other page.
Keycode constants for control keys
Constant |
Value |
Description |
vbKeyLButton |
0x1 |
Left mouse button |
vbKeyRButton |
0x2 |
Right mouse button |
vbKeyCancel |
0x3 |
CANCEL key |
vbKeyMButton |
0x4 |
Middle mouse button |
vbKeyBack |
0x8 |
BACKSPACE key |
vbKeyTab |
0x9 |
TAB key |
vbKeyClear |
0xC |
CLEAR key |
vbKeyReturn |
0xD |
ENTER key |
vbKeyShift |
0x10 |
SHIFT key |
vbKeyControl |
0x11 |
CTRL key |
vbKeyMenu |
0x12 |
MENU key |
vbKeyPause |
0x13 |
PAUSE key |
vbKeyCapital |
0x14 |
CAPS LOCK key |
vbKeyEscape |
0x1B |
ESC key |
vbKeySpace |
0x20 |
SPACEBAR key |
vbKeyPageUp |
0x21 |
PAGE UP key |
vbKeyPageDown |
0x22 |
PAGE DOWN key |
vbKeyEnd |
0x23 |
END key |
vbKeyHome |
0x24 |
HOME key |
vbKeyLeft |
0x25 |
LEFT ARROW key |
vbKeyUp |
0x26 |
UP ARROW key |
vbKeyRight |
0x27 |
RIGHT ARROW key |
vbKeyDown |
0x28 |
DOWN ARROW key |
vbKeySelect |
0x29 |
SELECT key |
vbKeyPrint |
0x2A |
PRINT SCREEN key |
vbKeyExecute |
0x2B |
EXECUTE key |
vbKeySnapshot |
0x2C |
SNAPSHOT key |
vbKeyInsert |
0x2D |
INSERT key |
vbKeyDelete |
0x2E |
DELETE key |
vbKeyHelp |
0x2F |
HELP key |
vbKeyNumlock |
0x90 |
NUM LOCK key |
Keycode constants for A - Z keys
Constant |
Value |
Description |
vbKeyA |
65 |
A key |
vbKeyB |
66 |
B key |
vbKeyC |
67 |
C key |
vbKeyD |
68 |
D key |
vbKeyE |
69 |
E key |
vbKeyF |
70 |
F key |
vbKeyG |
71 |
G key |
vbKeyH |
72 |
H key |
vbKeyI |
73 |
I key |
vbKeyJ |
74 |
J key |
vbKeyK |
75 |
K key |
vbKeyL |
76 |
L key |
vbKeyM |
77 |
M key |
vbKeyN |
78 |
N key |
vbKeyO |
79 |
O key |
vbKeyP |
80 |
P key |
vbKeyQ |
81 |
Q key |
vbKeyR |
82 |
R key |
vbKeyS |
83 |
S key |
vbKeyT |
84 |
T key |
vbKeyU |
85 |
U key |
vbKeyV |
86 |
V key |
vbKeyW |
87 |
W key |
vbKeyX |
88 |
X key |
vbKeyY |
89 |
Y key |
vbKeyZ |
90 |
Z key |
Keycode
constants for 0 - 9 keys
Constant |
Value |
Description |
vbKey0 |
48 |
0 key |
vbKey1 |
49 |
1 key |
vbKey2 |
50 |
2 key |
vbKey3 |
51 |
3 key |
vbKey4 |
52 |
4 key |
vbKey5 |
53 |
5 key |
vbKey6 |
54 |
6 key |
vbKey7 |
55 |
7 key |
vbKey8 |
56 |
8 key |
vbKey9 |
57 |
9 key |
Keycode
constants for numeric keypad keys
Constant |
Value |
Description |
vbKeyNumpad0 |
0x60 |
0 key |
vbKeyNumpad1 |
0x61 |
1 key |
vbKeyNumpad2 |
0x62 |
2 key |
vbKeyNumpad3 |
0x63 |
3 key |
vbKeyNumpad4 |
0x64 |
4 key |
vbKeyNumpad5 |
0x65 |
5 key |
vbKeyNumpad6 |
0x66 |
6 key |
vbKeyNumpad7 |
0x67 |
7 key |
vbKeyNumpad8 |
0x68 |
8 key |
vbKeyNumpad9 |
0x69 |
9 key |
vbKeyMultiply |
0x6A |
MULTIPLICATION SIGN (*) key |
vbKeyAdd |
0x6B |
PLUS SIGN (+)
key |
vbKeySeparator |
0x6C |
ENTER key |
vbKeySubtract |
0x6D |
MINUS SIGN (-)
key |
vbKeyDecimal |
0x6E |
DECIMAL POINT (.)
key |
vbKeyDivide |
0x6F |
DIVISION SIGN (/)
key |
Keycode
constants for function keys
Constant |
Value |
Description |
vbKeyF1 |
0x70 |
F1 key |
vbKeyF2 |
0x71 |
F2 key |
vbKeyF3 |
0x72 |
F3 key |
vbKeyF4 |
0x73 |
F4 key |
vbKeyF5 |
0x74 |
F5 key |
vbKeyF6 |
0x75 |
F6 key |
vbKeyF7 |
0x76 |
F7 key |
vbKeyF8 |
0x77 |
F8 key |
vbKeyF9 |
0x78 |
F9 key |
vbKeyF10 |
0x79 |
F10 key |
vbKeyF11 |
0x7A |
F11 key |
vbKeyF12 |
0x7B |
F12 key |
vbKeyF13 |
0x7C |
F13 key |
vbKeyF14 |
0x7D |
F14 key |
vbKeyF15 |
0x7E |
F15 key |
vbKeyF16 |
0x7F |
F16 key |
No comments:
Post a Comment