Visual Basic Editor
This is the complete list of visual basic keyboard shortcuts. Some of these will be very familiar like Ctrl + C and Ctrl + V will still copy and paste repectively. But some are quite different than their Excel counterpart, for example Ctrl + Y will not redo the undone command but instead will cut the entire line of code at the cursors current position.
Tab
Add one level of indentation to a highlighted block of code.
Back Space
Deletes one character to the left of the cursor.
Enter
Create a new line
Insert
Toggle insert mode on or off
Delete
Deletes one character to the right of the cursor.
Home
Move the cursor to the beginning of the current line.
End
Move the cursor to the end of the current line.
Page Up
Move the viewable area of the module up one page
Page Down
Move the viewable area of the module down one page
Up
Move the cursor up one line
Down
Move the cursor down one line
Left
Move the cursor one character to the left
Right
Move the cursor one character to the right
F1
Open visual basic editor help
F2
Open the visual basic object browser
F3
Perform the Find Next command
F4
Open the Properies window
F5
Run the current procedure.
F6
Move the cursor between split windows
F7
Go to Code window
F8
Step into code
Equivalent to Debug > Step Into
F9
Toggle code breakpoints on or off
Equivalent to Debug > Toggle Breakpoint
F10
Activate focus on the menu bar. Select different menu headings with left or right keys and open a menu with the down key.
Alt + A
Open the Add-Ins menu
Alt + D
Open the Debug menu
Alt + E
Open the Edit menu
Alt + F
Open the File menu
Alt + H
Open the Help menu
Alt + J
Open the Insert menu
Alt + O
Open the Format menu
Alt + Q
Close the visual basic editor.
Alt + R
Open the Run menu
Alt + T
Open the Tools menu
Alt + V
Open the View menu
Alt + W
Open the Window menu
Alt + F4
Close the visual basic editor.
Alt + F5
Run Error Handler
Alt + F6
Switch Between Last 2 Windows
Alt + F7
Step Error Handler
Alt + F11
Switch between the visual basic editor and Excel.
Alt + Tab
Cycle through all open Windows applications
Alt + Space Bar
Open visual basic editor system menu
Alt + Back Space
Undo the last command
Ctrl + A
Select all text in the current module
Ctrl + C
Copy the current selection
Ctrl + E
Export the currently selected module.
Ctrl + F
Open the Find dialog box
Ctrl + G
Open the Immediate window
Ctrl + H
Open the Replace dialog box
Ctrl + I
Display Quick Info for object selected
Ctrl + J
Show a list of available properties or methods
Equivalent to Edit > List Properties/Methods
Ctrl + J
Bring object to front when creating a user form
Ctrl + K
Send object to back when creating a user form
Ctrl + L
Equivalent to View > Call Stack
Ctrl + M
Import a module file
Equivalent to File > Import File…
Ctrl + N
Create a new line
Ctrl + P
Open the Print VBAProject dialog box
Ctrl + R
Open the Project window
Ctrl + S
Save the current project.
Ctrl + T
Open the Components dialog box
Ctrl + V
Paste the last item copied to your clipboard
Ctrl + W
Equivalent to Debug > Edit Watch
Ctrl + X
Cut the current selection
Ctrl + Y
Cut the entire current line
Ctrl + Z
Undo the last command
Ctrl + F2
Activate focus to the object selection drop down
Ctrl + F4
Close current window
Ctrl + F8
Equivalent to Debug > Run To Cursor
Ctrl + F9
Equivalent to Debug > Set Next Statement
Ctrl + F10
Activate focus on the menu bar. Select different menu headings with left or right keys and open a menu with the down key.
Ctrl + Tab
Cycle through all open visual basic windows
Ctrl + Space Bar
Auto complete current word
Ctrl + Back Space
Delete one word to the left of the cursor
Ctrl + Insert
Copy the current selection
Ctrl + Delete
Delete one word to the right of the cursor
Ctrl + Home
Move the cursor to the start of the current module
Ctrl + End
Move the cursor to the end of the current module
Ctrl + Page Up
Move the cursor to the start of the current procedure
Ctrl + Page Down
Move the cursor to the end of the current procedure
Ctrl + Up
Move the cursor to the previous procedure
Ctrl + Down
Move the cursor to the next procedure
Ctrl + Left
Move the cursor to the left by one word
Ctrl + Right
Move the cursor to the right by one word
Shift + F2
Go to variable declaration or object definition
Shift + F3
Find previous item from the cursor for the last item searched
Shift + F4
Find next item from the cursor for the last item searched
Shift + F8
Equivalent to Debug > Step Over
Shift + F9
Equivalent to Debug > Quick Watch
Shift + F10
Equivalent to right click to show menu
Shift + Tab
Remove one level of indentation from a highlighted block of code.
Shift + Insert
Paste the last item copied to your clipboard
Shift + Home
Select from the cursor to the start of the current line
Shift + End
Select from the cursor to the end of the current line
Shift + Page Up
Select from the cursor to the top of the module
Shift + Page Down
Select from the cursor to the bottom of the module
Shift + Up
Extend the current selection up one line
Shift + Down
Extend the current selection down one line
Shift + Left
Extend the current selection to the left by one character
Shift + Right
Extend the current selection to the left by one character
Ctrl + Shift + I
Equivalent to Edit > Parameter Info
Ctrl + Shift + J
Equivalent to Edit > List Constants
Ctrl + Shift + F2
Move the cursor to its previous position
Ctrl + Shift + F8
Equivalent to Debug > Step Out
Ctrl + Shift + F9
Equivalent to Debug > Clear All Breakpoints
