Microsoft Excel VBA Complete
(2013, 2016, 2019, 2021, 365)

VBA is the programming Interface for Excel and is used to automate tasks and generate easy to use code with other applications. VBA can be used in any version of Microsoft Excel. VBA’s ability to automate and produce efficient results makes any Excel worksheet easier to use. Simple codes are written into short programs and are used to perform specific, repetitive tasks. 

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()