Excel VBA Programming For Dummies
Book image
Explore Book Buy On Amazon
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.

About This Article

This article is from the book:

About the book author:

Dick Kusleika has been helping users get the most out of Microsoft Office products for more than 25 years through online forums, blogging, books, and conferences.

This article can be found in the category: