Introduction
  • Setting Yourself Up To Win
  • A Welcome Note From Paul and Course Source Code
  • BONUS 1: FREE VBA CHEAT SHEET - Workbooks, Worksheets and Ranges
  • BONUS 2: Excel VBA Website Resource
GETTING STARTED
  • A Quick Environment Check
  • Your First Macro
  • How to Create Modules
  • The Immediate Window - How to easily test your output
  • Using Intellisense - Let VBA help you write code
  • Getting Started - Support Text
Workbooks and Worksheets
  • Using Range to manipulate cells
  • How to get any Workbook
  • When to use each Workbook method
  • Making your code easy to read - Use a Workbook variable
  • How to get any Worksheet
  • Putting it all together - A sample Macro
  • VBA's best kept secret - the worksheet codename
  • The Sample Macro - How the code name improves it
  • Summary of Worksheets and Workbooks
  • Workbooks and Worksheets - Downloadable Guide
  • Workbooks and Worksheets Quiz
Using Variables
  • An introduction to Variables
  • How to do almost anything with a string
  • Using variables to write and read from Cells
Ranges, Cells and Offsets
  • Using Range to manipulate cells
  • Using Cells - How to choose cells at run time part 1
  • Using Offset - How to choose cells at run time part 2
  • Sample Macro - Writing to months using Offset
  • Sample Macro - Writing to months using Cells
  • Formatting Ranges - Making you work look good
Mini Project - Fruit Sales
  • Mini Project Workbooks
  • Introduction to Mini Project
  • Formatting the Cells
  • Write the Totals
  • Make it flexible with Offset
Debugging - How to see what your code is actually doing
  • What is Debugging
  • Stepping through code
  • Using Breakpoints
  • The Locals Window
  • The Watch Window
  • More on the Watch Window
If and Select
  • Using Conditions
  • The If Statement
  • If Statement with ElseIf
  • The Select Statement
  • More with the Select Statement
Loops
  • Introduction to Loops
  • The For Loop
  • More on the For Loop
  • The For Each Loop
  • The Do Loop
  • Using Do Loop with Until
  • Using Do Loop with While
  • While and Wend
  • Summary of Loops
Errors
  • Syntax Errors
  • Compiler Errors
  • Runtime Errors
  • Excel VBA Error Translator
How to open workbooks and use them
  • How to Open a Workbook
  • Opening Workbooks - User Dialog
  • Import Export Modules
Using Functions and Subs
  • Calling Subs
  • Arguments and Parameters
  • Functions
  • Subs v Functions
  • Passing Argument Types
  • Optional Arguments
How to Run Your Macros
  • Running - Using a Shortcut Key
  • Running - Quick Toolbar
  • Running - Using Buttons
Arrays
  • Introduction to Arrays
  • Declaring Arrays
  • Assigninng Arrays
  • Loop through arrays
  • Pass Arguments
  • Return from Function
How to Copy and Filter Data
  • Copying Data Introduction
  • Copying Data using the For Loop
  • Copying Data using the AutoFilter
  • Copying Data Using the Advanced Filter
How to Build a VBA Application from Scratch
  • Building a VBA Application Part 1
  • Building a VBA Application Part 2
  • Building a VBA Application Part 3