Microsoft Excel VBA Complete

Section 1: Basic Macro Concepts

How to Record a Macro

Re-recording a Macro

How to Play, Delete, Edit and Rename a Macro

Using Relative Referencing

Running a Macro While Recording Another

Section 2: Macro Security

Section 3: Personal Macro Workbook

Section 4: Dealing with Ranges That Change Size Over Time

Section 5: 8 Different Ways to Run a Macro

Adding to Ribbon, Creating Buttons, etc.

Section 6: Visual Basic for Applications - Basics

The Visual Basic Editor

The VBA Toolbars

Modules

Protecting a Module

Section 7: Writing Code

Objects, Properties and Methods

Using the With Construct

Recording vs. Writing – Pros and Cons

Getting Help with the Object Browser

Declaring and Using Variables

Using Formulas in Macros

Section 8: User Interaction

Input Boxes and Message Boxes

Formatting Input or Message Boxes with the Format Function

Section 9: Adding Special Characters Including Line Breaks

Section 10: IF Statements

Message Boxes That Allow for Input

Section 11: Running Other Procedures

Section 12: Event Trapping

On Error

Auto_Open() and Auto_Close()