Extremely Useful VBA Shortcuts Every Excel VBA User Should Know
20 Useful VBA Editor Keyboard Shortcuts These keyboard shortcuts help you write, edit, debug and manage VBA code faster in the Microsoft Visual Basic Editor. No. Shortcut Function 1 F5 Run the VBA macro or procedure 2 Ctrl + Break Interrupt or pause a running macro 3 F8 Execute code one line at a time (Step Into) 4 Shift + F8 Execute the next procedure without stepping into it (Step Over) 5 Ctrl + Shift + F8 Step out of the current procedure 6 Ctrl + F8 Run code up to the current cursor position 7 F9 Set or remove a breakpoint on the current line 8 Ctrl + Shift + F9 Clear all breakpoints 9 Ctrl + G Open the Immediate Window 10 Ctrl + R Open the Project Explorer 11 F4 Open the Properties Window 12 F2 Open the Object Browser 13 F7 Display the Code Window 14 Shift + F7 Display the Object or UserForm view when available 15 Ctrl + F Find text in the code 16 Ctrl + H Find and replace text in the code 17 Ctrl + S Save the current VBA project or workbook 18 Ctr...