Shortcut Keys for Working in the Visual Basic Editor Code Window

By John Walkenbach

Part of Excel VBA Programming For Dummies Cheat Sheet

At some point, you may find yourself working with many macros at one time. It can be tedious trying to navigate between and within macro procedures by clicking around with the mouse. These keyboard shortcuts allow you to quickly jump to a target procedure, navigate modules, and even find the starting point for variables.

What to Press What It Does
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.
Shift+F2 Goes to the selected function or variable.
Ctrl+Shift+F2 Goes to the last position.
Ctrl+Home Goes to the beginning of module.
Ctrl+End Goes to the end of module.
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.
Tab Indents the current line.
Shift+Tab Removes the indent for the current line.
Ctrl+J Lists the properties and methods for the selected object.