2004-VBE-Shortcuts
| No | Item | Content |
|---|---|---|
| 1 | windows activation | |
| 2 | Alt+F11 | Change Active windows on VBE or Excel Sheet |
| 3 | ctrl+G | Emmeditate Window |
| 4 | F7 | Code Editor |
| 5 | Shift+F7 | Object Ppoperty |
| 6 | F2 | Object Browser |
| 7 | F4 | Property Window |
| 8 | ctrl+R | Project Browser |
| 9 | Alt+V+H | Watch Window |
| 10 | Debug and run | |
| 11 | Alt+D + Enter | Compile VBA Project |
| 12 | F5 | Run |
| 13 | ctrl+G a | shortcut for debug |
| 14 | ctrl+G dev | shortcut for debug |
| 15 | ctrl+G ctrl+a del | Emmediate Window Clear |
| 16 | F8 | Step in |
| 17 | Shift+F8 | Step over |
| 18 | ctrl+F8 | Run to cursor |
| 19 | shift+ctrl+F8 | Step out |
| 20 | Alt+D + A | Add Watch |
| 21 | ctrl+W | Edit Watch |
| 22 | shift+F9 | Quick Watch |
| 23 | F9 | Toggle Breakpoint |
| 24 | shift+ctrl+F9 | Clear all breakpoints |
| 25 | ctrl+F9 | Set next statement |
| 26 | moudle import, export and insert | |
| 27 | ctrl+M | Import Module |
| 28 | ctrl+E | Export |
| 29 | Alt+i + M | Insert Module |
| 30 | Alt+i + C | Insert Class Module |
| 31 | jump | |
| 32 | shift+F2 | Jump to definition |
| 33 | shift+ctrl+F2 | Back to the last position |
| 34 | prp+D | Jump to definition |
| 35 | ctrl + ↑ | Go to previous definition |
| 36 | ctrl + ↓ | Go to next definition |
| 37 | ctrl+f | Search |
| 38 | F3 | Next |
| 39 | support functionality | |
| 40 | ctrl+space | complete word |
| 41 | ctrl+j | List properties and methods |
| 42 | ctrl+i | Quick information |
| 43 | shift+ctrl+j | List constants |
| 44 | shift+ctrl+i | Prameter information |
| 45 | Alt+E B | Bookmark |