Every Single VBA Feature in 10 Minutes

Поделиться
HTML-код
  • Опубликовано: 9 фев 2025
  • 👉 Ready to Master VBA?
    Check out my course: bit.ly/3XTnIm8
    Subscribe to the channel here: bit.ly/36hpTCY
    Every Single VBA Feature in 10 Minutes
    Want to master Excel VBA but short on time? In this fast-paced, power-packed video, I’ll cover every single feature of Excel VBA in just 10 minutes! From loops and conditions to Userforms, arrays, events, error handling, advanced techniques .... and much more!
    Whether you want to see what's available in VBA or you want to review what you know, this video has everything you need and only costs 10 minutes of your time.
    💻🔧 #VBATutorial #ExcelVBAOverview
    Useful VBA Shortcut Keys
    ========================
    Debugging:
    Compile the code: Alt + D + L OR Alt + D + Enter
    Run the code from the current sub: F5
    Step into the code line by line: F8
    Add a breakpoint to pause the code: F9 or click in the left margin
    Windows:
    View the Immediate Window: Ctrl + G
    View the Watch Window: Alt + V + H
    View the Properties Window: F4
    Switch between Excel and the VBA Editor: Alt + F11
    View the Project Explorer Window: Ctrl + R
    Writing Code:
    Search keyword under cursor: Ctrl + F3
    Search the word last searched for: F3
    Autocomplete word: Ctrl + Space
    Get the definition of the item under the cursor: Shift + F2
    Go to the last cursor position: Ctrl + Shift + F2
    Get the current region on a worksheet: Ctrl + Shift + 8 or Ctrl + *
    To move lines of code to the right(Indent): Tab
    To move lines of code to the left(Outdent): Shift + Tab
    Delete a Line: Ctrl + Y (note: this clears the clipboard)

Комментарии • 36