Excel VBA Introduction To The Coding VBA Section

The is the introduction to the coding section.

We've seen that recording macros is useful, but it only gets us part of the way there...to really harness the power of excel, we need to go beyond that, and learn to code...

VBA is a language just like any other. It has words, grammar and syntax. To code well, you need to know how to use them properly.

Through your coding career, you will write many snippets of useful code, and you should keep a copy of all of these in one central location, so you can use them again in future. This essentially enables you to code "Lego-style"...dropping all the bits one on top of the other until you've built a sophisticated solution.

I would advise against keeping these in the "Personal Workbook" as that is stored locally on your PC. Great when you're at home, but no good if you're at work...or your PC breaks or gets stolen! Keep all your code in your "Macro Book", and if possible, store it in the cloud...it's quite safe there!

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, 2019 and 365

Get this course now!

Level 1: Microsoft Excel Essentials: Level 1 Basics - Excel Made Easy
The complete 4 hour course is yours for a low cost monthly subscription (first 2 months free!):

Level 2: Microsoft Excel Essentials: Level 2 - Intermediate/Advanced
The complete 9 hour course is yours for a low cost monthly subscription (first 2 months free!):

Level 3: Microsoft Excel Essentials: Level 3 - VBA Programming + Macros

Alternatively, you can purchase the complete set in...
Excel Essentials: The Complete Excel Series - Level 1, 2 & 3

The WHOLE 27.5 Hour Excel Mastery Series In One! From Excel Novice To VBA Programmer...
Available to buy with lifetime access for just $16.99 (normally $200) here:

This course is for suitable Excel 2007, Excel 2010, Excel 2013, 2016, 2019 & 365

Videos in the Level 1 series:

Videos in the Level 2 series:

Videos in the Level 3 series: