VBA Keyboard Shortcuts

VBA Keyboard Shortcuts

How to perform the keyboard shortcuts: + (plus) separator means press and hold each key in order. , (comma) separator means press and release each key in order. Learn more at vba-shortcuts

# Shortcut 01. Running Macros & Code

Windows

1 Jump between Excel and the VB Editor Window Alt+F11

2 Run Macro/Procedure 3 Step Through Each Line of Code

4 Run to Cursor 5 Add a Break Point 6 Reset/stop code

7 Compile VBA Project

02. Navigating Through Code Modules & Procedures

8 Flip through open code windows 9 Flip backwards through open code windows

10

Jump to Definition (procedure name that text cursor is in)

11 Jump to last position

12 Jump to previous/next procedure

13 Select the entire procedure 14 Find Window 15 Replace Window

03. Writing Code

16 Complete Word 17 Delete entire line 18 Jumps to the beginning or end of a word

19 Selects the entire word

20

List properties/methods (Intellisense drop-down list)

21 Quick Info

04. VB Editor Windows

22 Immediate Window 23 Project Explorer Window

24 Properties Window 25 Insert a new code module 26 Insert a new userform

27 View userform code 28 Object Browser

F5 F8 Ctrl+F8 F9 Alt,R,R Alt,D,L

Ctrl+Tab Ctrl+Shift+Tab

Shift+F2

Ctrl+Shift+F2 Ctrl+Page Up/Down Ctrl+Shift+Page Down Ctrl+F Ctrl+H

Ctrl+Space Ctrl+Y Ctrl+ or Ctrl+Shift+ or

Ctrl+J

Ctrl+i

Ctrl+G Ctrl+R F4 Alt,I,M Alt,I,U F7 F2

Mac

Opt+F11 or Fn+Opt+F11 F5 Cmd+Shift+i

Ctrl+Tab Ctrl+Shift+Tab

Fn+Ctrl+Cmd+ or Fn+Ctrl+Cmd+Shift+ Cmd+F Cmd+Shift+H Ctrl+Space Cmd+Y Cmd+or Cmd+Shift+ or Cmd+J Cmd+i Ctrl+Cmd+G Ctrl+Cmd+R

Ctrl+Cmd+B

vba-shortcuts

1 of 1

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download