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

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.

FREE CHEAT SHEET: Get the free cheat sheet on VBA arrays here: (https://bit.ly/2MXsnz9)

Learn how to build 10 full Excel VBA applications from scratch: The Excel VBA Handbook Course(https://TheExcelVBAHandbook.com)

Free Excel VBA Resources
Excel VBA Articles (https://excelmacromastery.com/vba-articles/)

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.

Видео The 7 Keys Areas of Excel VBA (with code examples) канала Excel Macro Mastery