The 7 Keys Areas of Excel VBA with code examples

>> YOUR LINK HERE: ___ http://youtube.com/watch?v=6_YMKWsCyX0

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

#############################

New on site