Autoplay
Autocomplete
Previous Lesson
Complete and Continue
VBA Masterclass
Introduction
Welcome (1:29)
The big picture of VBA programming (3:19)
What you learn from this course (4:08)
How to practice: Quizzes, project files and assignments (2:29)
About your instructor (1:52)
Your setup (2:21)
Your Excel version (2:00)
Basic macros
What is a macro? (1:27)
Record a macro (1:57)
Play a macro (4:08)
Behind the scenes of a recording (3:06)
Edit the code (2:06)
Quiz
Basic VBA
What is VBA (1:14)
The VB editor (3:06)
Write your own code - part 1: Hello World (1:53)
Write your own code - part 2: Something useful (3:04)
Write your own code - part 3: Record the missing part (5:49)
Structure your code with comments (2:00)
The developer tab (1:50)
Save Excel files with macros (1:15)
Macro security (2:18)
Personal macros (2:52)
Quiz
Assignments (0:59)
Object-Oriented Programming in VBA
Object-Oriented Programming (3:12)
Using Object-Oriented Programming in VBA (2:43)
Quiz
Important objects, properties, and methods
Manipulating cells - part 1 (5:25)
Manipulating cells - part 2 (2:18)
Copy and paste (5:45)
Moving from cells (Offset method) (4:54)
Sheets (5:14)
Deleting (2:49)
CASE: John's Fitness - part 1 (10:15)
CASE: John's Fitness - part 2 (5:24)
Workbooks (6:37)
Quiz
Assignments (0:59)
Variables
What are variables? (1:46)
How to use variables in VBA (4:23)
Declaring variables: How and why (2:50)
Data types (2:57)
Declaring variables: An example (6:31)
Naming variables (2:13)
CASE: M&A Reporting Tool - Workbooks and variables (7:39)
CASE: John's Fitness - Copying with variables (6:16)
Quiz
Assignments (0:59)
What you've learned so far
Quick recap (2:24)
Big assignment - CASE: Reports for project management (1:59)
Big assignment - CASE: Reports for project management - solution (2:26)
Logic
What are IF statements? (1:21)
How to use IF statements (5:15)
AND + OR in VBA (4:30)
ElseIF (3:20)
Select Case (4:30)
CASE: Reports for project management (8:33)
Quiz
Assignments (0:59)
Loops
What is a loop? (1:12)
For loop (4:50)
Do While / Do Until (3:59)
For Each (4:14)
Loop within a loop (4:51)
Reverse loop (2:41)
Quiz
Assignments (0:59)
Logic within loops
IF statements inside loops (3:43)
CASE: Production and Proposal Tool - Loops and If statements, part 1 (4:04)
CASE: Production and Proposal Tool - Loops and If statements, part 2 (10:14)
Quiz
Big assignment - CASE: Production and proposal tool (0:55)
Big assignment - CASE: Production and proposal tool - solution (3:55)
User interaction
Interacting with the user (0:50)
MsgBox - Talking TO the user (8:31)
InputBox - Talking WITH the user (6:31)
Get user to select files and folders (7:04)
Send emails through Outlook from Excel (3:27)
CASE: Time Logging Application (5:45)
Quiz
Assignments (0:59)
Developing applications
How to begin developing an application (1:17)
The user (4:19)
The MVC framework (1:56)
CASE: John's Cosmetics (4:45)
Quiz
Optimizing your code
Make your code faster (2:10)
Screen updating and manual calculation (3:54)
Use fewer lines of code (1:22)
With statements (2:45)
Quiz
Assignments (0:59)
Error handling
What error handling is all about (1:19)
On Error Resume Next (1:40)
On Error GoTo handler (3:15)
On Error GoTo 0 (3:48)
CASE: John's Sports - Finances (6:17)
Quiz
Assignments (0:59)
What you've learned so far
Quick recap (3:29)
Additions to your VBA toolbox
CASE: M&A Reporting Tool - Manipulating strings (6:24)
User Defined Functions (7:58)
Filters (3:27)
Find and replace (1:54)
Save as PDF (2:23)
Running other macros from within a macro (2:57)
Your unlimited code bank (5:09)
Arrays - part 1 (2:14)
Arrays - part 2 (4:41)
Quiz
Events
What are events (0:43)
Run macro when file is saved (4:04)
Run macro when file is opened or closed (4:56)
Run macro when something changes (2:54)
Quiz
Assignments (0:59)
Build your own application
A very brief summary (3:39)
Big assignment - Joined list application (2:12)
Conclusion
What to do now (1:23)
Certificate (0:47)
Moving from cells (Offset method)
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock