Monday, March 18, 2019

Excel VBA Editor Keyboard Shortcuts


The complete list of Excel VBA Editor (VBE) keyboard shortcuts are for U.S. keyboard layout and Windows Operation system. 
#ActionShortcut
1HelpF1
2Object BrowserF2
3FindF3
4Properies WindowF4
5RunF5
6Switch Split WindowsF6
7Goto Window Of ObjectF7
8StepF8
9BreakpointF9
10Activate Menu BarF10
11Toggle Insert ModeInsert
12DeleteDelete
13Beginning Of LineHome
14End Of LineEnd
15Page UpPgUp
16Page DownPgDn
17Left
18Right
19Up
20Down
21IndentTab
22New LineEnter
23Delete Prev CharBackSpace
24Procedure DefinitionShift F2
25Find PrevShift F3
26Find NextShift F4
27Procedure StepShift F8
28Quick WatchShift F9
29Show Right Click MenuShift F10
30PasteShift Insert
31Select To Start Of LineShift Home
32Select To End Of LineShift End
33Select To Top Of ModuleShift PgUp
34Select To End Of ModuleShift PgDn
35Extend Selection Left 1 CharShift 
36Extend Selection Right 1 CharShift 
37Extend Selection UpShift 
38Extend Selection DownShift 
39Un-indentShift Tab
40Focus To Object BoxCtrl F2
41Close WindowCtrl F4
42Run To CursorCtrl F8
43Activate Menu BarCtrl F10
44Select All TextCtrl B
45CopyCtrl C
46Export ModuleCtrl E
47FindCtrl F
48Immediate WindowCtrl G
49ReplaceCtrl H
50Turn On Quick InfoCtrl I
51List MembersCtrl J
52Show Call StackCtrl L
53Import FileCtrl M
54New LineCtrl N
55PrintCtrl P
56Project WindowCtrl R
57SaveCtrl S
58Show Available ComponentsCtrl T
59PasteCtrl V
60CutCtrl X
61Cut Entire LineCtrl Y
62UndoCtrl Z
63CopyCtrl Insert
64Delete To End Of WordCtrl Delete
65Top Of ModuleCtrl Home
66End Of ModuleCtrl End
67Top Of Current ProcedureCtrl Page Up
68End Of Current ProcedureCtrl Page Down
69Left WordCtrl Left Arrow
70Right WordCtrl Right Arrow
71Previous ProcedureCtrl Up Arrow
72Next ProcedureCtrl Down Arrow
73Turn On Complete WordCtrl Space Bar
74Cycle WindowsCtrl Tab
75Delete To Start Of WordCtrl BackSpace
76Close VBEAlt F4
77Run Error HandlerAlt F5
78Switch Between Last 2 WindowsAlt F6
79Step Error HandlerAlt F7
80Return To ApplicationAlt F11
81Add-Ins MenuAlt A
82Debug MenuAlt D
83Edit MenuAlt E
84File MenuAlt F
85Help MenuAlt H
86Insert MenuAlt J
87Format MenuAlt O
88Close & ReturnAlt Q
89Run MenuAlt R
90Tools MenuAlt T
91View MenuAlt V
92Window MenuAlt W
93System MenuAlt Space Bar
94Cycle ApplicationsAlt Tab
95UndoAlt BackSpace
96Previous PositionCtrl Shift F2
97Clear All BreakpointsCtrl Shift F9
98Turn On Param InfoCtrl Shift I
99Turn On List PropertiesCtrl Shift J

No comments:

Post a Comment