Ready to master VBA?
Check out my full courses: https://courses.excelmacromastery.com/
Subscribe to the channel here: https://bit.ly/36hpTCY
FREE CHEAT SHEET: Get the free cheat sheet on VBA arrays here: https://bit.ly/2MXsnz9
(Note: If the download page doesn't work then make sure to turn off any popup blockers)

The 7 Keys Areas of Excel VBA (with code examples)

In this video I cover the 7 keys areas of Excel VBA. If you plan to master VBA then this can help shorten you journey by telling you what exactly to focus on.

This video is full of code examples. Theory is useful but nothing beats the actual code.

If you have any questions or comments please leave them below the video.


Useful VBA Shortcut Keys:
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 + 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.
F9(or click left margin): Add a breakpoint to pause the code.