Excel VBA Beginner Tutorial:

Welcome to Microsoft Excel Tutorial: VBA Beginners. In this tutorial you will be thrust into the world of Visual Basic for Applications specifically when used with Microsoft Excel. This is the first of 3 videos focusing on VBA and the 4th video in our Excel tutorial series. Be sure you have completed the first 3 videos (Excel 2019 Beginner, Intermediate, and Expert) this will ensure you have the necessary tools to be effective during these more advanced tutorials. You may also want to ensure you have a notebook and pen handy for taking notes and writing down specific steps to aid you as you progress through this tutorial.

In the VBA Beginner Tutorial, you will:

1.  Gain a better understanding of VBA and its language.
2.  Continue practicing Microsoft Excel Macro recording.
3.  Become familiar with the VBA user interface.
4. Be able to build simple functions using VBA Code.

Please note you will need to download 5 practices files to complete this video tutorial. I have provided links to the files in the Support Documents section below!

This first VBA Tutorial is roughly 2.5 hours in length and is broken into chapters: 

 CHAPTERS:

Start 0:00
Introduction 0:03
What is VBA? 1:44
Object Oriented Programming Languages 5:59
Turning on the Developer Tab 10:17
The Macro Recorder 13:40
Using Relative References 20:39
Recording Simple Macros 27:51
Multi-Step Macro Recording 39:25
Sort and Filter Macro Recording 45:26
Protecting and Formatting Sheets with the Macro Recorder 51:35
VBA Interface Setup 55:09
Recorder Code vs. Manual Code 1:01:11
Introduction to Editing Macros 1:12:28
Debugging Macros 1:16:53
Grammar in VBA 1:28:00
Macro Scripting Basics 1:33:04
Range 1:40:41
Selection & Color 1:47:14
Value and Clear 1:52:16
Active Sheet, Sheets, and Name 1:54:01
Current Region 1:56:40
Practice 1:58:08

Support Documents:

Simple Macros

Font Styles

Debugging

Creating Macro from Scratch

Insert & Format Text

Additional Support Documentation: (Optional)

Excel VBA - Handout