The 7 Vital Areas of the VBA Editor In this video I going to show you the vital parts of the Visual Basic Editor for VBA.
As this is the main tool for creating VBA code it is vital to Understand it.
SUBSCRIBE TO THE CHANNEL:
FREE CHEAT SHEET: Get the free cheat sheet on VBA arrays here: (
The Excel VBA Handbook Course(
Free Excel VBA Resources
Excel VBA Articles (
Useful VBA Shortcut Keys:
View the Immediate Window: Ctrl + G
View the Watch Window: Alt + V + H
Tab: To move lines of code to the right(Indent).
Shift + Tab: To move lines of code to the left(Outdent).
Shift + F2: Get the definition of the item under the cursor.
Ctrl + Shift + F2: Go to the last cursor position.
Ctrl + Space: AutoComplete Word.
Alt + F11: Switch between Excel and the VBA Editor.
Ctrl + G: view the Immediate Window
Ctrl + R: View the Project Explorer Window.
Ctrl + Shift + 8(or Ctrl + *): Get the current region on a worksheet.
F4: View the Properties Window.
F5: Run the code from the current sub.
F8: Step into the code.
F9(or click left margin): Add a breakpoint to pause the code.
Table of Contents:
00:00 - Introduction
01:08 - 1. Understanding the Main Windows
03:19 - 2. Mastering the Modules
06:00 - 3. Bossing the Bookmarks
07:11 - 4. Taming the Toolbars
08:31 - 5. Winning with Windows
10:43 - 6. Dominating the Debug Menu
11:42 - 7. Ruling the Run Menu
0 Comments