html>
VBA Shortcut Keys
Pearson Software Consulting Services
VBA Editor Shortcut Keys
|
|
|
|
|
|
|
NOTE: The key assignments listed here are for standard US-English keyboards. Key
mappings on non-US-English keyboards are slightly different. |
|
|
Key |
Alone |
Shift |
Ctrl |
Alt |
Shift Ctrl |
F1 |
Help |
|
|
|
|
F2 |
Object Browser |
Procedure Definition |
Focus To Object Box |
|
Previous Position |
F3 |
Copy |
Find Prev |
|
|
|
F4 |
Properies Window |
Find Next |
Close Window |
Close VBE |
|
F5 |
Run |
|
|
Run Error Handler |
|
F6 |
Switch Split Windows |
|
|
Switch Between Last 2 Windows |
|
F7 |
Goto Window Of Object |
|
|
Step Error Handler |
|
F8 |
Step |
Procedure Step |
Run To Cursor |
|
|
F9 |
Breakpoint |
Quick Watch |
|
|
Clear All Breakpoints |
F10 |
Activate Menu Bar |
Show Right Click Menu |
Activate Menu Bar |
|
|
F11 |
|
|
|
Return To Application |
|
F12 |
|
|
|
|
|
Key |
Alone |
Shift |
Ctrl |
Alt |
Shift Ctrl |
A |
Normal Characters |
|
Select All |
Add-Ins Menu |
|
B |
|
|
|
|
|
C |
|
|
Copy |
|
|
D |
|
|
|
Debug Menu |
|
E |
|
|
Export Module |
Edit Menu |
|
F |
|
|
Find |
File Menu |
|
G |
|
|
Immediate Window |
|
|
H |
|
|
Replace |
Help Menu |
|
I |
|
|
Turn On Quick Info |
|
Turn On Param Info |
J |
|
|
List Members |
Insert Menu |
Turn On List Properties |
K |
|
|
|
|
|
L |
|
|
Show Call Stack |
|
|
M |
|
|
Import File |
|
|
N |
|
|
New Line |
|
|
O |
|
|
|
Format Menu |
|
P |
|
|
Print |
|
|
Q |
|
|
|
Close & Return |
|
R |
|
|
Project Window |
Run Menu |
|
S |
|
|
Save |
|
|
T |
|
|
Show Available
Components |
Tools Menu |
|
U |
|
|
|
|
|
V |
|
|
Paste |
View Menu |
|
W |
|
|
|
Window Menu |
|
X |
|
|
Cut |
|
|
Y |
|
|
Cut Entire Line |
|
|
Z |
|
|
Undo |
|
|
` (~) |
|
|
|
|
|
Key |
Alone |
Shift |
Ctrl |
Alt |
Shift Ctrl |
1 (!) |
|
|
|
|
|
2 (@) |
|
|
|
|
|
3 (#) |
|
|
|
|
|
4 ($) |
|
|
|
|
|
5 (%) |
|
|
|
|
|
6 (^) |
|
|
|
|
|
7 (&) |
|
|
|
|
|
8 (*) |
|
|
|
|
|
9 (() |
|
|
|
|
|
0 ()) |
|
|
|
|
|
- |
|
|
|
|
|
= (+) |
|
|
|
|
|
[ |
|
|
|
|
|
] |
|
|
|
|
|
; (semicolon) |
|
|
|
|
|
' (apostrophe) |
|
|
|
|
|
: (colon) |
|
|
|
|
|
/ |
|
|
|
|
|
\ |
|
|
|
|
|
Key |
Alone |
Shift |
Ctrl |
Alt |
Shift Ctrl |
Insert |
Toggle Insert Mode |
Paste |
Copy |
|
|
Delete |
Delete |
|
Delete To End Of Word |
|
|
Home |
Beginning Of Line |
Select To Start Of Line |
Top Of Module |
|
|
End |
End Of Line |
Select To End Of Line |
End Of Module |
|
|
Page Up |
Page Up |
Select To Top Of Module |
Top Of Current
Procedure |
|
|
Page Down |
Page Down |
Select To End Of Module |
End Of Current Procedure |
|
|
Left Arrow |
Left |
Extend Selection Left 1 Char |
Left Word |
|
|
Right Arrow |
Right |
Extend Selection Right 1 Char |
Right Word |
|
|
Up Arrow |
Up |
Extend Selection Up |
Previous Procedure |
|
|
Down Arrow |
Down |
Extend Selection Down |
Next Procedure |
|
|
Space Bar |
|
|
Turn On Complete Word |
System Menu |
|
Tab |
Indent |
Un-indent |
Cycle Windows |
Cycle Applications |
|
Enter |
New Line |
|
|
|
|
BackSpace |
Delete Prev Char |
|
Delete To Start Of Word |
Undo |
|
|
|
|
|
|
You can download this as an Excel workbook
here. |
|
|
|
|
Created By Chip Pearson and
Pearson Software Consulting, LLC
This Page:
Updated: November 06, 2013
MAIN PAGE
About This Site
Consulting
Downloads
Page Index
Search
Topic Index
What's New
Links
Legalese And Disclaimers
chip@cpearson.com
© Copyright 1997-2007 Charles H. Pearson