Course Content
Section 1 – Introduction
-
1 – What is VBA
00:58 -
2 – Object Orientated Programming
06:17
Section 2 – Macros
-
1 – Macros Initial Setup
04:48 -
2 – Recording a Macro
05:41 -
3 – Saving a Macro
04:16
Section 3 – VBA Editor
-
1 – Launching VBA
04:03 -
2 – VB Editor
05:10 -
3 – Custom Menu
02:50 -
4 – Naming Projects
05:18 -
5 – Modules
02:42 -
6 – Code Window
01:43 -
7 – Comments
06:37
Section 4 – Variables and Procedures
-
1 – Introduction
01:30 -
2 – Vraibales
06:24 -
3 – Variable Exercise
05:54 -
4 – What are Procedures
05:45 -
5 – What are Procedures – Part Two
06:25 -
6 – What are Procedures – Part Three
03:00 -
7 – Message Boxes
04:58 -
8 – Input Box
05:58 -
9 – Input Box – Part Two
03:45 -
10 – Basic Navigation
11:54 -
11 – Sheets
13:06 -
12 – Cell Navigation
08:38 -
13 – Advanced Sheets
08:45 -
14 – Offset
05:25
Section 5 – Loops and IF Statements
-
1 – Introduction
00:47 -
2 – Operators
01:56 -
3 – Using Variables
12:09 -
4 – What is Automation
01:12 -
5 – For Loop
06:30 -
6 – Do Loops
06:08 -
7 – IF Statements
14:21 -
8 – IF Statements – Part Two
10:10 -
9 – Select Case
12:21
Section 6 – Error Handling
-
1 – Debugging
02:42
Section 7 – User Defined Functions
-
1 – UDFs
12:36
Section 8 – Assignments
-
1 – Introduction
00:39 -
2 Exercise 1 – Record a Macro
05:41 -
3 – Exercise 2 – Duplicating Data
07:45 -
4 – Exercise 3 – Generate a Report
12:42 -
5 – Generate a Report – Part Two
07:29 -
6 – Exercise 4 – Inner and Outer Loops
09:27 -
7 – Inner and Outer Loops – Part Two
11:54 -
8 – Inner and Outer Loops – Part Three
08:18 -
9 – Inner and Outer Loops – Part Four
09:45 -
10 – Inner and Outer Loops – Part Five
12:45
Section 9 – Creating Forms
-
1 – Form Controls
04:01 -
2 – Building the Form
15:17 -
3 – Initialize the Form
07:12 -
4 – Command Buttons
18:28 -
5 – Command Buttons – Part Two
07:00
