37 keyboard shortcuts for moving faster in the Visual Basic Editor

[elan asi]

37 keyboard shortcuts for moving faster in the Visual Basic Editor

 

The Visual Basic Editor (VBE) is the development environment in the Microsoft Office applications. Here are some handy keyboard shortcuts you can use to work more efficiently while entering, viewing, and editing code

 

The shortcuts

General
Alt + F11	This toggles switch displays the VBE from the application window and vice versa.
Ctrl + G	Displays the Immediate window.
Ctrl + F	Opens the Find dialog box.
F3	Finds Next.
Shift + F3	Finds Previous.
Ctrl + H	Opens the Replace dialog box.
Ctrl + Z	Cancels the last keyboard stroke or the last mouse operation (when possible).
F5	Runs the current procedure or continues execution after pausing.
Ctrl + Break	Halts a procedure.
Shift + F5	Terminates a procedure and resets all variables to their default values.
Shift + F10	Displays the active window’s shortcut menu.
Ctrl + R	Opens the Project Explorer.
F4	Opens the Properties window.
F2	Opens the Object Browser.
F1	Opens VBA Help.
F7	Gives focus to the open module window.
Code module
Ctrl + Down Arrow	Selects the next procedure.
Ctrl + Up Arrow	Selects the previous procedure.
Ctrl + Page Down	Shifts one screen down.
Ctrl + Page Up	Shifts one screen up.
Ctrl + Shift + F2	Goes to the last position.
Ctrl + Home	Goes to the beginning of module. (Also in the Immediate window.)
Ctrl + End	Goes to the end of module. (Also in the Immediate window.)
Ctrl + Right Arrow	Moves one word to the right.
Ctrl + Left Arrow	Moves one word to the left.
End	Moves to the end of the line.
Home	Moves to the beginning of the line.
Ctrl + Y	Deletes the current line.
Ctrl + Delete	Deletes to the end of a word.
Ctrl + Shift + F9	Clears all breakpoints.
Project Explorer
F7 Shift + Enter	Opens the selected file’s module.
Home	Selects the first file in the list.
End	Selects the last file in the list.
Right arrow	Expands a sublist.
Left arrow	Collapses a sublist.
Up arrow	Moves up the list one item at a time.
Down arrow	Moves down the list one item at a time

General
Alt + F11	This toggles switch displays the VBE from the application window and vice versa.
Ctrl + G	Displays the Immediate window.
Ctrl + F	Opens the Find dialog box.
F3	Finds Next.
Shift + F3	Finds Previous.
Ctrl + H	Opens the Replace dialog box.
Ctrl + Z	Cancels the last keyboard stroke or the last mouse operation (when possible).
F5	Runs the current procedure or continues execution after pausing.
Ctrl + Break	Halts a procedure.
Shift + F5	Terminates a procedure and resets all variables to their default values.
Shift + F10	Displays the active window’s shortcut menu.
Ctrl + R	Opens the Project Explorer.
F4	Opens the Properties window.
F2	Opens the Object Browser.
F1	Opens VBA Help.
F7	Gives focus to the open module window.
Code module
Ctrl + Down Arrow	Selects the next procedure.
Ctrl + Up Arrow	Selects the previous procedure.
Ctrl + Page Down	Shifts one screen down.
Ctrl + Page Up	Shifts one screen up.
Ctrl + Shift + F2	Goes to the last position.
Ctrl + Home	Goes to the beginning of module. (Also in the Immediate window.)
Ctrl + End	Goes to the end of module. (Also in the Immediate window.)
Ctrl + Right Arrow	Moves one word to the right.
Ctrl + Left Arrow	Moves one word to the left.
End	Moves to the end of the line.
Home	Moves to the beginning of the line.
Ctrl + Y	Deletes the current line.
Ctrl + Delete	Deletes to the end of a word.
Ctrl + Shift + F9	Clears all breakpoints.
Project Explorer
F7 Shift + Enter	Opens the selected file’s module.
Home	Selects the first file in the list.
End	Selects the last file in the list.
Right arrow	Expands a sublist.
Left arrow	Collapses a sublist.
Up arrow	Moves up the list one item at a time.
Down arrow	Moves down the list one item at a time.

General
Alt + F11	This toggles switch displays the VBE from the application window and vice versa.
Ctrl + G	Displays the Immediate window.
Ctrl + F	Opens the Find dialog box.
F3	Finds Next.
Shift + F3	Finds Previous.
Ctrl + H	Opens the Replace dialog box.
Ctrl + Z	Cancels the last keyboard stroke or the last mouse operation (when possible).
F5	Runs the current procedure or continues execution after pausing.
Ctrl + Break	Halts a procedure.
Shift + F5	Terminates a procedure and resets all variables to their default values.
Shift + F10	Displays the active window’s shortcut menu.
Ctrl + R	Opens the Project Explorer.
F4	Opens the Properties window.
F2	Opens the Object Browser.
F1	Opens VBA Help.
F7	Gives focus to the open module window.
Code module
Ctrl + Down Arrow	Selects the next procedure.
Ctrl + Up Arrow	Selects the previous procedure.
Ctrl + Page Down	Shifts one screen down.
Ctrl + Page Up	Shifts one screen up.
Ctrl + Shift + F2	Goes to the last position.
Ctrl + Home	Goes to the beginning of module. (Also in the Immediate window.)
Ctrl + End	Goes to the end of module. (Also in the Immediate window.)
Ctrl + Right Arrow	Moves one word to the right.
Ctrl + Left Arrow	Moves one word to the left.
End	Moves to the end of the line.
Home	Moves to the beginning of the line.
Ctrl + Y	Deletes the current line.
Ctrl + Delete	Deletes to the end of a word.
Ctrl + Shift + F9	Clears all breakpoints.
Project Explorer
F7 Shift + Enter	Opens the selected file’s module.
Home	Selects the first file in the list.
End	Selects the last file in the list.
Right arrow	Expands a sublist.
Left arrow	Collapses a sublist.
Up arrow	Moves up the list one item at a time.
Down arrow	Moves down the list one item at a time

General
Alt + F11	This toggles switch displays the VBE from the application window and vice versa.
Ctrl + G	Displays the Immediate window.
Ctrl + F	Opens the Find dialog box.
F3	Finds Next.
Shift + F3	Finds Previous.
Ctrl + H	Opens the Replace dialog box.
Ctrl + Z	Cancels the last keyboard stroke or the last mouse operation (when possible).
F5	Runs the current procedure or continues execution after pausing.
Ctrl + Break	Halts a procedure.
Shift + F5	Terminates a procedure and resets all variables to their default values.
Shift + F10	Displays the active window’s shortcut menu.
Ctrl + R	Opens the Project Explorer.
F4	Opens the Properties window.
F2	Opens the Object Browser.
F1	Opens VBA Help.
F7	Gives focus to the open module window.
Code module
Ctrl + Down Arrow	Selects the next procedure.
Ctrl + Up Arrow	Selects the previous procedure.
Ctrl + Page Down	Shifts one screen down.
Ctrl + Page Up	Shifts one screen up.
Ctrl + Shift + F2	Goes to the last position.
Ctrl + Home	Goes to the beginning of module. (Also in the Immediate window.)
Ctrl + End	Goes to the end of module. (Also in the Immediate window.)
Ctrl + Right Arrow	Moves one word to the right.
Ctrl + Left Arrow	Moves one word to the left.
End	Moves to the end of the line.
Home	Moves to the beginning of the line.
Ctrl + Y	Deletes the current line.
Ctrl + Delete	Deletes to the end of a word.
Ctrl + Shift + F9	Clears all breakpoints.
Project Explorer
F7 Shift + Enter	Opens the selected file’s module.
Home	Selects the first file in the list.
End	Selects the last file in the list.
Right arrow	Expands a sublist.
Left arrow	Collapses a sublist.
Up arrow	Moves up the list one item at a time.
Down arrow	Moves down the list one item at a time.

 

 

Regards,

Elan