1. Introduction
  • Promo Video
  • 1.1 Introduction to VBA for MS Excel
  • 1.2 Download Course Materials
2. Getting Started
  • 2.1 Setting up the Environment
  • 2.2 Recording a Macro
  • 2.3 Your First VBA Program
  • 2.4 Object Hierarchy
  • 2.5 Variable Basics
  • 2.6 Set Command
  • 2.7 Range vs Cell
  • 2.8 Debugging and Debug Windows
3. Useful Procedures / Techniques
  • 3.1.1 Contiguous Data Range - Part 1
  • 3.1.2. Contiguous Data Range - Part 2
  • 3.2 Copy & Paste
  • 3.3 With Command
  • 3.4 Formulas
  • 3.5 Question Box
  • 3.6.1 Inputbox
  • 3.6.2 Inputbox Validation
  • 3.7 Sorting
  • 3.8.1 Error Handling - Part 1
  • 3.8.2 Error Handling - Part 2
  • 3.8.3 Error Handling - Part 3
4. VBA Programming Techniques
  • 4.1.1 Variables and Datatypes - Part 1
  • 4.1.2 Variables and Datatypes - Part 2
  • 4.2 Public, Private & Constant Variables
  • 4.3.1 If Then Else - Part 1
  • 4.3.2 If Then Else - Part 2
  • 4.4 If Then ElseIf
  • 4.5 Select Case
  • 4.6.1 For Loop - Part 1
  • 4.6.2 For Loop - Part 2
  • 4.7 Do Until Loop
  • 4.8 Do Loop Until
  • 4.9 Do While Loop & 4.10 Do Loop While
  • 4.11 Calling Procedures
  • 4.12.1 Functions - Part 1
  • 4.12.2 Functions - Part 2
  • 4.13.1 Arrays - Static Arrays
  • 4.13.2 Arrays - Dynamic Arrays
  • 4.13.3 Arrays - Erase Static Array
  • 4.13.4 Arrays - Two Dimensional Arrays
  • 4.13.5 Arrays - Read From and Write To Sheet
  • 4.13.6 Arrays - Quick Read From and Write To Sheet
5. Interesting Examples
  • 5.1 Make Contents Sheet
  • 5.2 Add Sheet to Workbook
  • 5.3.1 Duplicate Counter - Part 1
  • 5.3.2 Duplicate Counter - Part 2
6. Worksheet Events
  • 6.1 Activate Sheet Event
  • 6.2 Deactivate Sheet Event
  • 6.3 Change Sheet Event
7. Workbook Events
  • 7.1 Open Workbook Event
  • 7.2 New Sheet Event
  • 7.3 Sheet Deactivate Event
  • 7.4 Before Save Event