Excel Macros: Shortcut Keys for Navigating the VBE Project Window

By Michael Alexander

Part of Excel Macros For Dummies Cheat Sheet

What to Press on Your Keyboard What It Does
Up arrow Moves up the project list one item at a time
Down arrow Moves down the project list one item at a time
Home Moves to the first file in the project list
End Moves to the last file in the project list
Right arrow Expands the selected folder
Left arrow Collapses the selected folder
F7 + Shift + Enter Opens the code window for the selected file