Here are the most important shortcut keys.
General
| F1 | Help – sometimes useful, sometimes not |
| F4 | Open the properties window |
Editing code
| ALT+F11 | Open the code editor |
| CTRL+Space | Autocomplete – very useful |
| CTRL+S | Save – do it often! |
| CTRL+Z | Undo – I use this one a lot |
| TAB | Indent the selected code |
| CTRL+G | Open the immediate window, to try out code |
| CTRL+Y | Delete the current line |
| ALT+Q | Switch back to the worksheet |
Debugging
| F9 | Set a breakpoint |
| F8 | Run the next statement, stepping into Sub calls |
| SHIFT+F8 | Run the next statement, skipping over Sub calls |
| CTRL+F8 | Debug – Run until VBA reaches the line that's selected |
| CTRL+G | Open the immediate window, to try out code |