Excel VBA The 15 Golden Rules Of Coding

Please login in order to report media.

  • Uploaded 8 months ago in the category How to programming

    https://youtu.be/zw9ydY-GVXo - Excel VBA The 15 Golden Rules Of Coding

    The 15 Golden Rules of Coding

    1.

    Work on a backup (there is NO undo)
    2.

    Think through the process
    3.

    Test, test and test again
    4.

    Keep a “Macro Book”
    5.

    Be EXPLICIT...VBA can’t guess
    6.

    Code simply, and in small chunks
    7.

    Rem EXTENSIVELY
    8.

    Re-use your code
    9.

    Code iteratively
    10.

    Shorter code runs FASTER, but...
    11.

    ...Ugly code still works
    12.

    Use Excels built in “Translator”
    13.

    Is there a FUNCTION for that?
    14.

    There’s ALWAYS more than one way
    15.

    Have FUN!!!


    This is a sample lecture from my course, Microsoft Excel Essentials: Level 3 - VBA Programming.

    This course is for Excel 2007, Excel 2010, Excel 2013 and Excel 2016


    Check out the latest offers at:
    http://alangjarvis.com

    Or get these courses now:

    Level 1: Microsoft Excel Essentials: Level 1 Basics - Excel Made Easy
    The complete 4 hour course for just $10 (normally $80) here:

    https://www.udemy.com/excel-from-zero-to-hero-level-1-complete-beginners/?couponCode=IGOTTHISONYOUTUBE

    Level 2: Microsoft Excel Essentials: Level 2 - Intermediate/Advanced
    The complete 7.5 hour course for just $10 (normally $100) here:

    https://www.udemy.com/excel-essentials-level-2-intermediateadvanced/?couponCode=IGOTTHISONYOUTUBE

    Level 3: Microsoft Excel Essentials: Level 3 - VBA Programming + Macros
    The complete 13.5 hour course for just $15 (normally $150) here:

    https://www.udemy.com/excel-essentials-level-3-vba-programming/?couponCode=IGOTTHISONYOUTUBE

    Alternatively, you can get the complete set in...

    Excel Essentials: The Complete Excel Series - Level 1, 2 & 3
    The WHOLE 24.5 Hour Excel Mastery Series In One! From Excel Novice To VBA Programmer...for just $20 (normally $200) here:

    https://www.udemy.com/excel-essentials-the-complete-series-levels-1-2-3/?couponCode=IGOTTHISONYOUTUBE

    Not got Excel? For the best deals on Office 365 check here:
    US - http://amzn.to/2ipvYbA
    UK - http://amzn.to/2xrUiMs

    Videos in the Level 1 series:
    https://youtu.be/uNFJNJk_kyo
    https://youtu.be/g4ExVFkrj7I
    https://youtu.be/Sd7w4YrVKmQ
    https://youtu.be/XPfZA-KrOrM
    https://youtu.be/CGNP1jKAhGA
    https://youtu.be/6At4-dfrWSM
    https://youtu.be/6QSm0iNA-gc
    https://youtu.be/NWRFK2SOTtA
    https://youtu.be/CYCFs4dQnm8

    Videos in the Level 2 series:
    https://youtu.be/4B4VFgHfcCI
    https://youtu.be/B6G5Vu97GIw
    https://youtu.be/-YL6h4ZaPec
    https://youtu.be/fSwl1kEwMdg
    https://youtu.be/ij0_SkPhB_M
    https://youtu.be/MHbOHpBxTa0
    https://youtu.be/bDPJP2t28_A
    https://youtu.be/Y5E2FZ8KHgM
    https://youtu.be/LSGUDpBPWb8
    https://youtu.be/DhwXh6IplPk
    https://youtu.be/B5k1lbIC5lQ
    https://youtu.be/DZq9TxIaecI
    https://youtu.be/41Ke-oEEGUk
    https://youtu.be/xn0VSwQ0Vpc
    https://youtu.be/haZpJhLJbdA

    Videos in the Level 3 series:
    https://youtu.be/IzbCv0yWAUI
    https://youtu.be/zw9ydY-GVXo
    https://youtu.be/DZc0ekkOFTg
    https://youtu.be/L0V1WkC7bzQ
    https://youtu.be/2vUSnj9ULYk
    https://youtu.be/itTaurKxZp0
    https://youtu.be/w4d_SUMqNxM
    https://youtu.be/9OOJu4pxOGc
    https://youtu.be/rkf7Wc-CQIY
    https://youtu.be/2QXcBWYlL_I
    https://youtu.be/rHqnzyw-asw
    https://youtu.be/QeUgI_d-ljU
    https://youtu.be/DjlzkGmDOok
    https://youtu.be/JM7NFLDGaJE
    https://youtu.be/kNkL21Iw9bk

  • excelvbathe15goldenrulesofcoding