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

Workbook and Worksheets

• 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
• The Sample Macro – How the code name improves it
• Summary of Worksheets and Workbooks

Using Variables

• An introduction to Variables
• How to do almost anything with a string
• Using variables to write and read from Cell

Ranges, Cells, Offsets

• Using Cells – How to choose cells at run time
• Using Offset – How to choose cells at run time part
• 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

• 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

How to Open Workbooks and Use them

• How to Open a Workbook
• Opening Workbooks – User Dialog
• Import Export Modules

Using Function and Sub

• 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
• Assigning 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

User form Overview

• Adding Controls to the UserForm
• Working with UserForm Control Properties
• Adding Excel VBA Code to the UserForm’s Events
• Displaying the Excel VBA UserForm to the User

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