Excel VBA Advanced Tutorial:

Welcome to the Excel VBA Advanced tutorial. This is the second of three videos focusing on Excel VBA and the fifth video in our Excel tutorial series. Be sure you have completed the first 4 videos as 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 Advanced Tutorial you will:

1. Get a better understanding when working with variables in Macros.
2. Become familiar with building and running command loops in Macros.
3. Understand the steps to Address and Cal Data Set Macros.
4. Understand and work with input variable and end user dialog.

Please note you will need to download a number of Sample Files to complete this video tutorial. I have provided links to the files in the Support Documents section below!

 This second VBA Tutorial is roughly 2.5 hours in length and is broken into Chapters:

CHAPTERS:

Start 0:00
Variables 0:03
Variable Rules 7:59
For Next Loop Basics 11:18
For Next Loop Doubled 15:44
For Next Loop Triple 19:47
For Each Loop 22:11
Exit For Statement 23:50
Do While Loop 27:07
Do While Not Empty Loop 30:32
Do Until Loop 32:53
Do Loop UNTIL 35:11
Count and Offset 36:49
End, Address, Call Statement 48:23
Practice 55:35
Using the FIND Tool in a Macro 1:03:47
Message Boxes 1:14:50
Input Boxes 1:22:58
Code Continuation Character and vbCrLf Constant 1:27:16
If Then, ElseIF, and Else 1:33:44
Select Case 1:40:13
Multiple Variables 1:42:58
Practice 1:46:09

Support Documents:

Simple Variables

For Next Loop

Do Loop

Worksheet, Count, Offset, Copy

Address, Call, End

Report Generator

FIND Macros

Input Boxes for Sorting

Additional Support Documentation: (Optional)

Excel VBA - Handout