This section provides an overview of the most important keyboard shortcuts that are used during program development. We shall not go into keyboard shortcuts that hold generally under Windows (such as Ctrl+C to copy to the clipboard). The keyboard shortcuts have been organized by the uses to which they are most frequently put.
CHANGING THE ACTIVE WINDOW | |
Alt+F11 | switches between Excel and the development environment |
Ctrl+Tab | switches among all Visual Basic windows |
Alt+F6 | switches between the last two active windows |
Ctrl+G | switches into the immediate window (debug window) |
Ctrl+R | switches to the project explorer |
F2 | switches into the object browser |
F4 | switches to the properties window |
F7 | switches to the code window |
PROPERTIES WINDOW | |
Shift+Tab | jumps to the object list field |
Ctrl+Shift+X | jumps to the property whose name begins with the letter X |
PROGRAM EXECUTION | |
F5 | start the program |
Ctrl+Break | program interrupt |
F8 | execute a single command (single step execution) |
Shift+F8 | execute a command or call a procedure (procedure step execution) |
Ctrl+F8 | execute a procedure up to the cursor position |
Ctrl+Shift+F8 | execute the current procedure to the end |
F9 | set a breakpoint |
Ctrl+F9 | determine the location of the next command |
CODE WINDOW | |
Tab | indent the selected block of lines |
Shift+Tab | unindent the selected block of lines |
Ctrl+Y | delete lines |
Alt+Backspace | undo changes |
Ctrl+Z | redo changes |
Ctrl+ ‘ / “ | move the cursor to the next or previous procedure |
Shift+F2 | move to procedure definition or variable declaration |
Ctrl+Shift+F2 | return to previous cursor position (undo Shift+F2) |
F6 | change code sector (in split windows) |
Ctrl+F | find |
F3 | find again |
Ctrl+H | find and replace |
Ctrl+Spacebar | complete keyword or variable name |
Tab | complete selection in IntelliSense listbox |
Esc | exit IntelliSense listbox |