Shortcut Keys

Also known as Accelerator Keys or Hot Keys.


Function Keys

F1Displays help on a keyword or (Help > Microsoft Visual Basic for Applications Help).
F2Displays the (View > Object Browser) window.
F3Finds the next occurrence of the last word you searched for using (Ctrl + F).
F4Displays the (View > Properties Window) if it is not displayed.
F5Runs the current procedure or continues if in Debug Mode.
F6Switches focus between the two code windows when using (Window > Split).
F7Displays the (View > Code) window. Can also be used to display the corresponding userform code module when a Userform is active.
F8Step into code line by line. Can be used to startd debugging subroutines that require no arguments.
F9Inserts or toggles a breakpoint.
F10Toggles the activatation of the Menu bar.
F1
Displays help on a keyword or (Help > Microsoft Visual Basic for Applications Help).
F2
Displays the (View > Object Browser) window.
F3
Finds the next occurrence of the last word you searched for using (Ctrl + F).
F4
Displays the (View > Properties Window) if it is not displayed.
F5
Runs the current procedure or continues if in Debug Mode.
F6
Switches focus between the two code windows when using (Window > Split).
F7
Displays the (View > Code) window. Can also be used to display the corresponding userform code module when a Userform is active.
F8
Step into code line by line. Can be used to startd debugging subroutines that require no arguments.
F9
Inserts or toggles a breakpoint.
F10
Toggles the activatation of the Menu bar.

Shift + Function

Shift + F2Moves to the definition of the procedure or function (View > Definition).
Shift + F3Finds the previous occurrence of the last word you searched for using (Ctrl + F).
Shift + F4Repeats the last Find, the same as (Edit > Find Next).
Shift + F7Displays the Userform object corresponding to the active userform code module. This can be used in conjunction with the F7 (View > Code) to quickly toggle between the code and the object.
Shift + F8Step over code line by line, execute one procedure at a time.
Shift + F9Activates the Quick Watch window adding the current variable.
Shift + F10Displays the Shortcut menu for the selected item.
Shift + F2
Moves to the definition of the procedure or function (View > Definition).
Shift + F3
Finds the previous occurrence of the last word you searched for using (Ctrl + F).
Shift + F4
Repeats the last Find, the same as (Edit > Find Next).
Shift + F7
Displays the Userform object corresponding to the active userform code module. This can be used in conjunction with the F7 (View > Code) to quickly toggle between the code and the object.
Shift + F8
Step over code line by line, execute one procedure at a time.
Shift + F9
Activates the Quick Watch window adding the current variable.
Shift + F10
Displays the Shortcut menu for the selected item.

Ctrl + Function

Ctrl + F2Activates the Object Box in the top left corner of the Code window.
Ctrl + F4Closes the active MDI child window.
Ctrl + F5Runs the error handler code or returns the error to the calling procedure. Does not affect the setting for error trapping on the General tab of the Options dialog box.
Ctrl + F6Moves to the next open window. This is exactly the same as (Ctrl + Tab).
Ctrl + F8Run to the cursor.
Ctrl + F9Moves the current line of execution to this location. This defines the location for the next command that is executed.
Ctrl + F10Activate the Menu bar.
Ctrl + F2
Activates the Object Box in the top left corner of the Code window.
Ctrl + F4
Closes the active MDI child window.
Ctrl + F5
Runs the error handler code or returns the error to the calling procedure. Does not affect the setting for error trapping on the General tab of the Options dialog box.
Ctrl + F6
Moves to the next open window. This is exactly the same as (Ctrl + Tab).
Ctrl + F8
Run to the cursor.
Ctrl + F9
Moves the current line of execution to this location. This defines the location for the next command that is executed.
Ctrl + F10
Activate the Menu bar.

Other + Function

Alt + F4Closes the Visual Basic Editor window and returns to the application.
Alt + F5Resume execution though the error handler / run error handler.
Alt + F8Steps into the error handler or returns the error to the calling procedure. Does not affect the setting for error trapping on the General tab of the Options dialog box.
Alt + F11Toggles between the Visual Basic Editor and the application.
Ctrl + Shift + F2Moves back to the previous position (View > Last Position).
Ctrl + Shift + F8Step out of code.
Ctrl + Shift + F9Clear all breakpoints from the active project.
Alt + F4
Closes the Visual Basic Editor window and returns to the application.
Alt + F5
Resume execution though the error handler / run error handler.
Alt + F8
Steps into the error handler or returns the error to the calling procedure. Does not affect the setting for error trapping on the General tab of the Options dialog box.
Alt + F11
Toggles between the Visual Basic Editor and the application.
Ctrl + Shift + F2
Moves back to the previous position (View > Last Position).
Ctrl + Shift + F8
Step out of code.
Ctrl + Shift + F9
Clear all breakpoints from the active project.

Ctrl + Letters

Ctrl + ASelect all text in the current module.
Ctrl + CCopies the selection to the clipboard.
Ctrl + EDisplays the (File > Export File) dialog box.
Ctrl + FDisplays the (Edit > Find) dialog box.
Ctrl + GDisplays the (View > Immediate window) window.
Ctrl + HDisplays the (Edit > Replace) dialog box.
Ctrl + ITurn on quick information (Edit > Quick Info).
Ctrl + JDisplays a drop-down of available properties (Edit > List Properties/Methods).
Ctrl + LShow the call stack (View > Call Stack).
Ctrl + MDisplays the (File > Import File) dialog box.
Ctrl + NInserts a new line and positions the cursor at the start of the line. Pressing Enter will maintain the same indentation.
Ctrl + PDisplays the (File > Print) dialog box.
Ctrl + RDisplays the (View > Project Explorer) window.
Ctrl + SSaves (File > Save).
Ctrl + TDisplays the Components dialog box listing all the available components. This is a Visual Basic 6.0 dialog box.
Ctrl + VPastes the current clipboard entry.
Ctrl + XCuts the selection to the clipboard.
Ctrl + YCuts the entire line to the clipboard.
Ctrl + ZUndo the last action (Edit > Undo).
Ctrl + A
Select all text in the current module.
Ctrl + C
Copies the selection to the clipboard.
Ctrl + E
Displays the (File > Export File) dialog box.
Ctrl + F
Displays the (Edit > Find) dialog box.
Ctrl + G
Displays the (View > Immediate window) window.
Ctrl + H
Displays the (Edit > Replace) dialog box.
Ctrl + I
Turn on quick information (Edit > Quick Info).
Ctrl + J
Displays a drop-down of available properties (Edit > List Properties/Methods).
Ctrl + L
Show the call stack (View > Call Stack).
Ctrl + M
Displays the (File > Import File) dialog box.
Ctrl + N
Inserts a new line and positions the cursor at the start of the line. Pressing Enter will maintain the same indentation.
Ctrl + P
Displays the (File > Print) dialog box.
Ctrl + R
Displays the (View > Project Explorer) window.
Ctrl + S
Saves (File > Save).
Ctrl + T
Displays the Components dialog box listing all the available components. This is a Visual Basic 6.0 dialog box.
Ctrl + V
Pastes the current clipboard entry.
Ctrl + X
Cuts the selection to the clipboard.
Ctrl + Y
Cuts the entire line to the clipboard.
Ctrl + Z
Undo the last action (Edit > Undo).

Other + Letters

Alt + ADisplays the (Add-ins) menu.
Alt + DDisplays the (Debug) menu.
Alt + EDisplays the (Edit) menu.
Alt + FDisplays the (File) menu.
Alt + HDisplays the (Help) menu.
Alt + IDisplays the (Insert) menu.
Alt + ODisplays the (Format) menu.
Alt + QCloses the Visual Basic Editor window and returns to application.
Alt + RDisplays the (Run) menu.
Alt + TDisplays the (Tools) menu.
Alt + VDisplays the (View) menu.
Alt + WDisplays the (Window) menu.
Ctrl + Shift + IDisplays the tooltip showing you parameter information (Edit > Parameter Info). This is only useful if you have (Tools > Options, Editor tab, Auto List Members & Auto Quick Info) unchecked.
Ctrl + Shift + JDisplays a drop-down of available constants (Edit > List Constants). This is only useful if you have (Tools > Options, Editor tab, Auto List Members & Auto Quick Info) unchecked.
Alt + A
Displays the (Add-ins) menu.
Alt + D
Displays the (Debug) menu.
Alt + E
Displays the (Edit) menu.
Alt + F
Displays the (File) menu.
Alt + H
Displays the (Help) menu.
Alt + I
Displays the (Insert) menu.
Alt + O
Displays the (Format) menu.
Alt + Q
Closes the Visual Basic Editor window and returns to application.
Alt + R
Displays the (Run) menu.
Alt + T
Displays the (Tools) menu.
Alt + V
Displays the (View) menu.
Alt + W
Displays the (Window) menu.
Ctrl + Shift + I
Displays the tooltip showing you parameter information (Edit > Parameter Info). This is only useful if you have (Tools > Options, Editor tab, Auto List Members & Auto Quick Info) unchecked.
Ctrl + Shift + J
Displays a drop-down of available constants (Edit > List Constants). This is only useful if you have (Tools > Options, Editor tab, Auto List Members & Auto Quick Info) unchecked.

Entering

Shift + InsertPastes the current clipboard entry.
TabIndents the current line of code or completes intellisense.
Shift + TabUnIndents the current line of code (outdents).
EnterEnters a new line into the code module.
Shift + Insert
Pastes the current clipboard entry.
Tab
Indents the current line of code or completes intellisense.
Shift + Tab
UnIndents the current line of code (outdents).
Enter
Enters a new line into the code module.

Selecting

Shift + HomeSelects to the start of the line.
Shift + EndSelects to the end of the line.
Shift + Page UpSelects to the top of the module.
Shift + Page DownSelects to the bottom of the module.
Shift + Home
Selects to the start of the line.
Shift + End
Selects to the end of the line.
Shift + Page Up
Selects to the top of the module.
Shift + Page Down
Selects to the bottom of the module.

Extending

Shift + Left ArrowExtends the selection one character to the left.
Shift + Right ArrowExtends the selection one character to the right.
Shift + Up ArrowExtends the selection up one line.
Shift + Down ArrowExtends the selection down one line.
Shift + Left Arrow
Extends the selection one character to the left.
Shift + Right Arrow
Extends the selection one character to the right.
Shift + Up Arrow
Extends the selection up one line.
Shift + Down Arrow
Extends the selection down one line.

Manouvering

Ctrl + TabMoves to the next module or window.
Alt + TabMoves to the next application.
HomeMoves to the beginning of the current line.
EndMoves to the end of the current line.
Page UpMoves one screen upwards.
Page DownMoves one screen downwards.
Left ArrowMoves left one character.
Right ArrowMoves right one character.
Up ArrowMoves up one line.
Down ArrowMoves down one line.
Ctrl + HomeMoves to the top of the module.
Ctrl + EndMoves to the bottom of the module.
Ctrl + Page UpMoves to the top of the current procedure.
Ctrl + Page DownMoves to the start of the next procedure.
Ctrl + Left ArrowMoves one word to the left.
Ctrl + Right ArrowMoves one word to the right.
Ctrl + Up ArrowMoves to the sub or function directly above.
Ctrl + Down ArrowMoves to the sub or funciton directly below.
Ctrl + Tab
Moves to the next module or window.
Alt + Tab
Moves to the next application.
Home
Moves to the beginning of the current line.
End
Moves to the end of the current line.
Page Up
Moves one screen upwards.
Page Down
Moves one screen downwards.
Left Arrow
Moves left one character.
Right Arrow
Moves right one character.
Up Arrow
Moves up one line.
Down Arrow
Moves down one line.
Ctrl + Home
Moves to the top of the module.
Ctrl + End
Moves to the bottom of the module.
Ctrl + Page Up
Moves to the top of the current procedure.
Ctrl + Page Down
Moves to the start of the next procedure.
Ctrl + Left Arrow
Moves one word to the left.
Ctrl + Right Arrow
Moves one word to the right.
Ctrl + Up Arrow
Moves to the sub or function directly above.
Ctrl + Down Arrow
Moves to the sub or funciton directly below.

Other

BackspaceDeletes the character to the left of the cursor in the code window.
Ctrl + BreakStops execution and enters break-mode.
Ctrl + InsertCopies the selection to the clipboard.
Ctrl + EnterEnters a new line (or carriage return) into a userform control.
Ctrl + DeleteDelete to the end of the word.
Ctrl + SpacebarDisplays a drop-down of matching properties (Edit > Complete Word). This is only useful if you have (Tools > Options, Editor tab, Auto List members) unchecked.
Ctrl + BackspaceDeletes to the start of the word.
Alt + SpacebarActivates the Control Box in the top left hand corner of the visual basic editor window.
Alt + BackspaceUndo the last action (Edit > Undo).
InsertToggle Insert Mode.
DeleteDelete the character to the right of the cursor in the code window.
Backspace
Deletes the character to the left of the cursor in the code window.
Ctrl + Break
Stops execution and enters break-mode.
Ctrl + Insert
Copies the selection to the clipboard.
Ctrl + Enter
Enters a new line (or carriage return) into a userform control.
Ctrl + Delete
Delete to the end of the word.
Ctrl + Spacebar
Displays a drop-down of matching properties (Edit > Complete Word). This is only useful if you have (Tools > Options, Editor tab, Auto List members) unchecked.
Ctrl + Backspace
Deletes to the start of the word.
Alt + Spacebar
Activates the Control Box in the top left hand corner of the visual basic editor window.
Alt + Backspace
Undo the last action (Edit > Undo).
Insert
Toggle Insert Mode.
Delete
Delete the character to the right of the cursor in the code window.

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited TopPrevNext