Master Microsoft Excel Macros and VBA with 6 Simple Projects

Understanding the Why and How Behind Excel Macros

Introduction to Project #1: Inserting and Formatting Text

Project #1: Start Recording!

Project #1: Running a Macro with a Button

Project #1: Opps! I Need to Edit My Macro

Project #1: Practical Uses of Excel Macros

Excel VBA Concepts

The Visual Basic Editor

Excel VBA Modules

Creating Excel VBA Procedures

Understanding Excel VBA Variables

Working with Excel VBA Loops to Repeat Blocks of Code

Building Logic with an IF Statement

Project #2: Intro to Interacting with the User

Project #2: Breaking Down the VBA Code

Project #2: Prompting the User for Information

Project #2: Alerting the User of Errors

Project #2: Other Practical Uses of Messages Boxes and Input Boxes

Project #3: Intro to Cleaning and Formatting Data

Project #3: Using the Macro Recorder to Lay the Foundation

Project #3: Preparing to Use to the Macro Recorder

Project #3: Inserting Headers

Project #3: Formatting Headers

Project #3: Putting it All Together with a Little VBA Magic

Project #4: Automate Microsoft Excel Formulas

Project #4: Automate the SUM Function through Code

Project #4: Loop the SUM Function Over Multiple Worksheets

Project #5: Creating the Final Report

Project #5: Putting it all Togehter to Create the Final Report

Project #6: Working with Excel VBA Forms

Project #6: Creating an Excel VBA Form

Project #6: Adding Controls to the Form

Project #6: Changing Control and Form Properties

Project #6: Adding VBA Code to the Intialize Event

Project #6: Adding VBA Code to the ComboBox Change Event

Project #6: Adding VBA Code to the Add Worksheet Button

Project #6: Adding VBA Code to the Create Report Button

Project #6: Showing the Form

Congratulations