Start

Introduction

What is VBA?

Object Oriented Programming Languages

Turning on the Developer Tab

The Macro Recorder

Using Relative References

Recording Simple Macros

Multi-Step Macro Recording

Sort and Filter Macro Recording

Protecting and Formatting Sheets with the Macro Recorder

VBA Interface Setup

Recorder Code vs. Manual Code

Introduction to Editing Macros

Debugging Macros

Grammar in VBA

Macro Scripting Basics

Range

Selection & Color

Value and Clear

ActiveSheet, Sheets, and Name

CurrentRegion

Practice

Start

Introduction

What is VBA?

Object Oriented Programming Languages

Turning on the Developer Tab

The Macro Recorder

Using Relative References

Recording Simple Macros

Multi-Step Macro Recording

Sort and Filter Macro Recording

Protecting and Formatting Sheets with the Macro Recorder

VBA Interface Setup

Recorder Code vs. Manual Code

Introduction to Editing Macros

Debugging Macros

Grammar in VBA

Macro Scripting Basics

Range

Selection & Color

Value and Clear

ActiveSheet, Sheets, and Name

CurrentRegion

Practice

Start

Introduction

VBA Basics

Example of Object-Oriented Programming Using Excel

Why VBA?

Adding the Developer Tab to the Ribbon

Filling in the Record Macro Dialog

Recording Macros

Exploring VBE

Viewing VBE Options and Reviewing Macro Code

Adding Useful Commands to the Toolbar

Saving Macro-Enabled Workbooks

Reviewing and Changing Security Settings

VBA Basics Recap

Excel Object Model Hierarchy and Collections

Introduction to Modules and Procedures

Understanding Modules

Recording More Macros

Creating Sub-Procedures from the Menu in VBE

Reviewing New Code and Editing Existing Code

Testing Calling Procedures

Creating Event Procedures

Reviewing and Testing Function Procedures

Getting Context Sensitive Help in VBE

Conclusion

Start

VBA Basics

Excel Object Model Hierarchy and Collections

Modules and Procedures

Variables, Data Types, and Intrinsic Functions

Object Variables

Controlling Program Execution

Forms and Controls

Pivot Tables

Debugging Code

Conclusion

Start

Introduction

VBA Overview

Adding the Developer Tab to the Excel Ribbon

Recording Macros

Testing Macros

Customizing VBE Toolbar

Editing VBA Code Generated by Recording a Macro

Saving Macro-Enabled Workbooks

Testing Macro Changes in Another Excel File

Getting Started Recap

Excel Object Model Hierarchy Overview and Collections

Introduction to Procedures and Functions

Naming Rules and Conventions for Procedures

Starting Macro Recordings from the Status Bar

Reviewing Methods and Examples

Reviewing Newly Generated Code

Modifying Two Existing Sub-Procedures

Executing Procedures and Creating a Calling Procedure from Scratch

Testing Calling Procedures

Creating Event Procedures

Creating Function Procedures

Testing Function Procedures in the Immediate Window

Accessing Context Specific Help from VBE

Conclusion

Start

VBA Overview/Getting Started

Procedures and Functions

Expressions, Variables, and Intrinsic Functions

Controlling Program Execution

Forms and Controls

Pivot Tables in VBA

Code Debugging

Start

Introduction

Introduction to Variables

Creating Sub-Procedures and Declaring Procedure Level Variables

Intrinsic Functions

With-End With Structure and Offset Property

Testing ParseVIN Procedures

Message Boxes

Creating and Testing Message Boxes in Event Procedures

Testing Modified Procedures

Introduction to Object Variables

Testing Object Variables by Stepping Into Code

Controlling Program Execution

Control Structures and Conditional Branching

If-Then-Else-End If Construct

Testing Rearranged Code and Function Procedures

Setting With-End With Structure in Calling Procedures

Select Case Statement

Using Text Files to Insert Function Procedures

Looping Constructs - Do Loops

Sub-Procedure to Select, Cut, and Paste to Other Sheets

Looping Constructs - For Loops

For To Next Loop and Encountering Errors

Creating and Testing For Each Next Loop

Conclusion

Welcome message & hellos (skip this if you want)

What is covered in this video (VBA intro, practical example, VBA vs. Python vs. Office Scripts)

Introduction to VBA - What is it and when / where to use it?

Using "Macro Recorder" and creating your first VBA macro - simple example

Understanding the recorded macro

Customizing the recorded macro by adding your own code

Adding a button to run the macro

Adding the macro to Excel ribbon

ChatGPT and VBA... my thoughts

VBA Object model - explained

Creating a simple "TO DO List" App with VBA

IF condition in VBA

Adding time stamp (with variables in VBA)

Showing a message with msgbox()

Highlighting done activities (with conditional formatting)

Python vs. Excel

Highlighting done activities (with VBA)

Writing a loop in VBA (For Each)

Discussion about VBA vs. other technologies, Q&A and random musings (watch if you have time)

Master File

Assumptions

Multiple Worksheets

Three Sources of Code

Deleting the Sheets from the File Deleting those Excess Sheets

Objects and Collections

Rename those Sheets

Master Routine

Yes no Message Box

Type Mismatch Error from Vba

Video Series Overview

Adding Buttons and Macros

Creating a Button

Opening the Visual Basic Editor

Creating a Macro Routine

Inserting a Message Box

Inserting a Button

Aligning Buttons

Editing the Text of a Button

Conclusion

Start

Introduction

Introduction to Forms and Controls

Inserting and Modifying UserForm Objects

Using Label Control on Forms

Using Command Button Control on Forms

Using Combo Box Control on Forms

Using Option Button Control on Forms

Changing Option Button Properties

Testing and Modifying Tab Order on Forms

Using Code to Populate Combo Boxes and Setting Defaults

Reviewing Inserted Code

Testing Modified and Inserted Code

Writing Code to Display Forms

Introduction to Pivot Tables in VBA

PivotCache, PivotTable, and PivotFields Objects

Recording Macros to Set Pivot Table Fields

Reviewing Macro Codes

Creating Code to Set Pivot Table Fields

Finalizing Forms

Finalizing Code

Creating and Modifying Function Procedures

Adding QAT Icon to Launch Form

Testing Final Forms

Conclusion

Start

Introduction

Variables - Overview, Naming Rules, and Conventions

Option Explicit Statement and Removing Variables from Memory

Declaring Procedure Level String Variables and Reviewing Intrinsic Functions and VIN Characters

Testing the Sub Procedure and Introduction to the With-End With Structure and the Offset Property

Troubleshooting the Procedure and Re-Testing It

Overview of MsgBox and InputBox Functions

Testing the Message Box Function

Testing the Input Box Function

Using Object Variables in a Sub Procedure

Expressions, Variables, and Intrinsic Functions Recap

Controlling Program Execution and Control of Flow Structures

Boolean Expressions, Logical Operators, and Comparison Operators

Using the If-Then-End If Construct

Calling a Function Procedure from a Sub Procedure

Creating a Function Procedure to Extract the Year from the VIN

Creating a Function Procedure Using the If-Then-ElseIf-End If Construct

Select Case Overview - End Select Construct

Creating Functions by Using a Text File

Testing Final Three Function Procedures for Extraction

Using a Do While Loop to Populate the Spreadsheet

Testing the Append and Clear Sheet Procedures

Using the For-Each-Next Loop

Conclusion

Overview

What Do We Mean by Automation in Excel

Excel Vba Building Blocks

Changing the Format of the Data

Advantages of Excel Vba

Creating a Powerpoint Presentation

Three Sources of Code

Sources of Code

The Macro Recorder

Macro Recorder