| Section 01: Introduction |
|
Recording Macros vs Writing VBA |
|
00:04:00 |
|
Understanding Objects in Excel VBA |
|
00:07:00 |
|
Understanding VBA Syntax and Parts of Speech |
|
00:10:00 |
|
Activating the Developer tab |
|
00:01:00 |
|
Recording a basic Macro |
|
00:05:00 |
|
Absolute vs Relative Macro recording |
|
00:04:00 |
| Section 02: Exploring the Visual Basic Environment |
|
Introduction to the Visual Basic Environment |
|
00:02:00 |
|
The Project Explorer |
|
00:02:00 |
|
The Properties Window |
|
00:02:00 |
|
The Code Window |
|
00:04:00 |
|
Immediate, Locals and Watch Window |
|
00:03:00 |
|
Dealing with Modules |
|
00:03:00 |
|
Comments in Excel VBA |
|
00:01:00 |
| Section 03: The Range Object |
|
Introduction and Changing Cell Values |
|
00:10:00 |
|
Adding a text to a cell |
|
00:01:00 |
|
Dealing with Named Ranges |
|
00:03:00 |
|
Value vs Text Property |
|
00:04:00 |
|
Row and Column properties |
|
00:02:00 |
|
The Select Method |
|
00:02:00 |
|
The Count Property |
|
00:04:00 |
|
The Address Property |
|
00:09:00 |
|
The Formula Property |
|
00:03:00 |
|
The Number Format Property |
|
00:07:00 |
|
The Font Property |
|
00:08:00 |
| Section 04: Understanding the Cells Collection Object |
|
What is the cells object? |
|
00:06:00 |
|
Using the Cells collection to affect cells positionally within a range |
|
00:05:00 |
|
Affecting all cells within a sheet |
|
00:02:00 |
|
Combining Range and cells objects |
|
00:03:00 |
| Section 05: Working with Sheets/Worksheets |
|
Selecting Sheets |
|
00:06:00 |
|
Adding Sheets |
|
00:11:00 |
|
Sheets vs Worksheets |
|
00:04:00 |
|
Copying Sheets |
|
00:05:00 |
|
Moving Sheets |
|
00:01:00 |
|
Deleting Sheets |
|
00:04:00 |
| Section 06: Understanding Variables in Excel VBA |
|
Introduction to Variables |
|
00:06:00 |
|
Variable Data Types |
|
00:09:00 |
|
Declaring Variables |
|
00:14:00 |
|
Object Variables |
|
00:08:00 |
|
Calling a procedure from Another Procedure & Variable Scope |
|
00:03:00 |
|
Public and Private Variables |
|
00:07:00 |
|
Declaring Constants |
|
00:04:00 |
|
Exercises-Variables |
|
00:06:00 |
| Section 07: Dealing with Workbooks |
|
Referring to Workbooks-Different ways |
|
00:04:00 |
|
Closing Workbooks |
|
00:03:00 |
|
Adding and Saving Workbooks Part 1 – Save method |
|
00:04:00 |
|
Adding and Saving Workbooks Part 2 – Save as method |
|
00:10:00 |
|
Opening Workbooks |
|
00:06:00 |
| Section 08: Must Know Excel VBA Logic |
|
Finding the Last row |
|
00:09:00 |
|
Finding the Last Column |
|
00:04:00 |
|
Finding the next row |
|
00:04:00 |
|
The WITH Statement |
|
00:04:00 |
|
Comparison operators in Excel VBA |
|
00:01:00 |
|
IF Statements- Simple IF Statements |
|
00:07:00 |
|
IF THEN ELSE Structure |
|
00:03:00 |
|
IF THEN ELSEIF Structure |
|
00:07:00 |
|
Nested IFs |
|
00:04:00 |
|
OR – AND logical operators |
|
00:07:00 |
|
NOT Logical operator |
|
00:03:00 |
|
CASE Statements Part 1 – Single Case Statements |
|
00:09:00 |
|
CASE Statements Part 2 – Nested Case Statements |
|
00:06:00 |
|
Case Statements-Exercise |
|
00:01:00 |
|
GOTO and Labels |
|
00:03:00 |
| Section 09: Looping in Excel VBA |
|
Loops-Introduction |
|
00:01:00 |
|
FOR NEXT Loop |
|
00:11:00 |
|
Exit For |
|
00:09:00 |
|
Exercise – For Next loop |
|
00:01:00 |
|
FOR EACH Loop – Intro |
|
00:07:00 |
|
FOR EACH Loops – More examples |
|
00:05:00 |
|
Do Loop – Introduction |
|
00:04:00 |
|
Do Loop Example |
|
00:01:00 |
|
Do Until |
|
00:02:00 |
|
Do While |
|
00:02:00 |
|
Do while vs Do until – Movies Example |
|
00:04:00 |
|
Exit Do Statement |
|
00:05:00 |
|
Exercise – Do Loop |
|
00:01:00 |
| Section 10: Interacting with Your Users |
|
The Messagebox – Introduction |
|
00:03:00 |
|
Messagebox – Inputs |
|
00:07:00 |
|
Messagebox – Capturing the User’s input |
|
00:05:00 |
|
Adding a new line to your VBA Strings |
|
00:02:00 |
|
The Inputbox – introduction |
|
00:04:00 |
|
Inputbox – Example1 – Capturing a user’s name |
|
00:05:00 |
|
Inputbox – Employee Database Example Part 1 |
|
00:05:00 |
|
Inputbox – Employee Database Example Part 2 |
|
00:04:00 |
|
Exercise – InputBox |
|
00:02:00 |
| Section 11: Error Handling in Excel VBA |
|
Error Handling – Introduction |
|
00:09:00 |
|
Different Error types in action |
|
00:04:00 |
|
On Error Goto statement |
|
00:04:00 |
|
Resetting the error handling Status with On Error Goto |
|
00:02:00 |
|
The Err Object |
|
00:07:00 |
|
Setting a Breakpoint |
|
00:02:00 |
| Section 12: Triggering Code with Events! |
|
Worksheet Events – Selection change |
|
00:08:00 |
|
Worksheet Events – Worksheet Activate event |
|
00:03:00 |
|
Worksheet Events – Deactivate event |
|
00:02:00 |
|
Worksheet Events – Before Delete Event |
|
00:02:00 |
|
Worksheet Events – Before Double click event |
|
00:08:00 |
|
Worksheet Events – Before Right Click event |
|
00:03:00 |
|
Worksheet Events – Calculate event |
|
00:03:00 |
|
Enabling and Disabling Events |
|
00:03:00 |
|
Worksheet events – Worksheet change event |
|
00:11:00 |
|
Worksheet events – Follow Hyperlink event |
|
00:03:00 |
|
Worksheet events – Exercise |
|
00:01:00 |
|
Workbook Events – Workbook open event |
|
00:05:00 |
|
Workbook Events – Workbook Activate event |
|
00:02:00 |
|
Workbook Events – Workbook Before save event |
|
00:06:00 |
|
Workbook Events – Workbook Aftersave event |
|
00:04:00 |
|
Workbook Events – Workbook Beforeclose event |
|
00:09:00 |
|
Workbook Events – Workbook BeforePrint event |
|
00:03:00 |
|
Workbook Events – Workbook De-activate events |
|
00:02:00 |
|
Workbook Events – New Chart event |
|
00:08:00 |
|
Workbook Events – New sheet event |
|
00:03:00 |
|
Workbook Events – Sheet calculate event |
|
00:03:00 |
|
Workbook Events – Sheet De-activate event |
|
00:06:00 |
|
Workbook Events – Follow Hyperlink event |
|
00:02:00 |
|
Workbook Events – Workbook Window Activate event |
|
00:06:00 |
|
Workbook Events – Workbook Window De-Activate event |
|
00:02:00 |
|
Workbook Events – Window Resize event |
|
00:02:00 |
|
Exercise- Workbook Events |
|
00:01:00 |
| Resources |
|
Resources – Excel VBA/Macros Foundations |
|
00:00:00 |
