Autoplay
Autocomplete
Previous Lesson
Complete and Continue
VBA Programming for Excel: Zero to Mastery
Introduction
VBA Programming (2:23)
Exercise: Meet Your Classmates and Instructor
ZTM Plugin + Understanding Your Video Player
Cheatsheet
Set Your Learning Streak Goal
Introducing Macros and VBA
A Note to Mac Users (2:26)
Hello World - Introducing Macros (5:39)
Opening Macro-Enabled Files (3:22)
Editing Macros (11:23)
Subroutine Structure (11:00)
Buttons and Shapes (7:17)
The Personal Workbook (10:01)
Exercise: Introducing Macros and VBA
Let's Have Some Fun (+ More Resources)
Variables and User Input
Introducing Variables (4:22)
Using Variables in Expressions (11:49)
Option Explicit (4:26)
Gathering User Input (6:53)
Gathering User Input - A More Complex Example (7:38)
Exercise: Variables and User Input
Unlimited Updates
Programming in VBA
Comments (5:12)
Error Handling With IF Statements (13:19)
Branching Logic With Else and ElseIf (11:58)
Formatting Code (4:39)
Naming Conventions (6:10)
Using Worksheet Functions in VBA (9:22)
User Defined Functions - A Simple Example (6:45)
User Defined Functions - A More Complex Example (7:48)
Converting UDFs to Add-Ins (5:54)
Objects, Properties and Methods (6:24)
Exercise: Programming in VBA
Course Check-In
Userforms
Introducing Userforms (14:34)
Adding Functionality to Userforms (13:41)
Enhancing Userforms With Option Buttons (15:06)
Enhancing Userforms With Combo Boxes (11:30)
Exercise: Userforms
Combining Multiple Userforms (11:10)
Introducing the InfoManager Project (5:28)
InfoManager Part 1 - Intro (2:43)
InfoManager Part 1 - Solution (7:27)
Implement a New Life System
Working With Ranges in VBA
Targeting Ranges With VBA (12:35)
Advanced Methods For Targeting Ranges (9:06)
Properties and Methods of Ranges (11:10)
Exercise: Working with Ranges
Exercise: Imposter Syndrome (2:55)
Dynamic Methods For Targeting Ranges (12:31)
Capturing Ranges As User Input (5:54)
Writing Formulas With VBA (16:27)
InfoManager Part 2 - Intro (6:15)
InfoManager Part 2 - Solution (17:55)
Loops
Do Loops (8:12)
Debugging Tools (4:43)
Validating User Input With Do Loops (11:52)
For Next Loops (9:47)
Nested Loops (15:16)
For Each Loops (8:07)
Loops - Example Subroutine (15:19)
Loops - Example UDF (10:19)
Exercise: Loops
InfoManager Part 3 - Intro (5:34)
InfoManager Part 3 - Solution (17:08)
Arrays
Introducing Arrays (7:52)
Dynamic Arrays With ReDim Preserve (14:06)
The SPLIT Function (17:15)
Exercise: Arrays
InfoManager Part 4 - Intro (10:43)
InfoManager Part 4 - Solution (9:32)
Worksheets and Workbooks
Working With Worksheets (4:12)
Iterating Through Worksheets (16:21)
Consolidating Worksheets (12:54)
Working with Workbooks (11:40)
The Workbooks Collection (5:14)
Opening Multiple Workbooks (13:51)
Consolidating Workbooks (15:08)
Worksheet and Workbook Events (11:18)
Exercise: Worksheets and Workbooks
InfoManager Part 5 - Intro (8:42)
InfoManager Part 5 - Solution (19:14)
Pivot Tables
External Data and VBA (14:22)
Controlling Pivot Tables With VBA (14:48)
Exercise: Pivot Tables
InfoManager Part 6 - Intro (6:28)
InfoManager Part 6 - Solution (15:09)
Where To Go From Here?
Thank You! (1:17)
Review This Course!
Become An Alumni
Learning Guideline
ZTM Events Every Month
LinkedIn Endorsements
Validating User Input With Do Loops
This lecture is available exclusively for ZTM Academy members.
If you're already a member,
you'll need to login
.
Join ZTM To Unlock All Lectures