Top 130 Visual Basics Shortcut Keys (Excel-PDF)

In the last few years, computers are changed completely. Earlier computers were only dependent on MS-Dos. But now computers are dependent on Graphic User Interface. In such OS mouse can be used. An example of a Graphic User Interface is Windows. In the era of Windows a need for a programming language that is based on graphic users interface. In this sequence, there are Visual C++, Visual Basic, Visual Java, etc.

Visual Basic is a programming tool or an application tool introduced by Microsoft Corporation. It is a new version of the Basic programming language. Visual Basic is an Object-oriented programming language. It helps in making applications based on the graphical user interface. Visual Basic was developed by the BASIC programming language. It was developed by Microsoft Corporation. It was introduced to develop the Windows operating system by Microsoft.

Visual Basic is a programming language, you can create software by using this language. It is also called VB. This language is easy to learn. This is a third-generation programming language under event-driven language. An important feature of Visual Basic is that you can create application software as per the requirement of the users. Visual Basic provides Integrated Development Environment or IDE. You can develop applications using Mouse. You can type the codes using the keyboard. The codes must be executable. There are several inbuilt codes in this language. Any programmer can execute these codes easily. One of the important features of Visual Basic is Data Base handling. Half of the application development is done by this feature only. This language also gives us the facility to access the internet as well.

In 2008 Microsoft Corporation stopped promoting Visual Basic. It introduced VB.Net developed in 2002 and launched in 2008.

History of Visual basics

In the year 1960, an American Professor Jhon required a programming language that his students could learn easily. But at that time most programming languages were difficult and only professionals were using the programming languages. So he developed a programming language. Its name was BASICS (Beginner’s All-purpose Symbolic Instruction Code). It was easy and powerful which made it popular very easily.

Versions of Visual basics

Several versions of VB were developed by Microsoft-

Microsoft Visual Basic 1.0 1991
Microsoft Visual Basic 2.0 1992
Microsoft Visual Basic 3.0 1993
Microsoft Visual Basic 4.0 1995
Microsoft Visual Basic 5.0 1997
Microsoft Visual Basic 6.0 1998 – 2008

In this article we have some keyboards shortcut keys which will let us learn about Visual basics that is a powerful tool in excel though this we can code in excel and add any features of own choice, these keys are different then excel counterpart will help you to increase your workflow and save your time. We have also provided you with Excel and PDF files which can be downloaded from the Download button below which can be used for future reference.

Visual Basic Shortcut Keys

1.Manouverin:

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.

2.Other:

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.

3.Selecting:

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.

4.Extending:

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.

5.Other + Letters:

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.

6.Entering:

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.

7.Other + Function:

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.

8.Ctrl + Letters:

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).

9.Ctrl + Function:

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.

10.Shift + Function:

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.

11.Function Keys:

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.

Thank you for reading, If you liked this article, then definitely share it with your friends on social media, so that they too can get this information.

Download Excel File

Download File

Download PDF File

Download File

Related Articles: