Introduction

Sorting with VBA – Part: 1

Sorting with VBA – Part: 2

Sorting with VBA – Part: 3

Filtering with VBA – Part: 1

Filtering with VBA – Part: 2

Introduction

How to create a Function in VBA

How to make your own user-defined (UDF) function (Custom Functions)

How to convert a user-defined function to an Excel Add-In

Custom Function Examples

How to borrow functions from Excel

Message Box and Built-In Functions EXAMPLES

Using Worksheet Functions in VBA

❓QUIZ 6: Using VBA and Worksheet Functions

Introduction

The If-Then Structure

For-Next loops

Applications of Looping Methodologies - Part:1

Applications of Looping Methodologies - Part:2

Applications of Looping Methodologies - Part:3

Iterating through a Selection vs. a Range

Using the For Each... Next statement

DEMO: Using IF..ELSE Statements with Macros

DEMO: Using FOR…NEXT Statements with Macros

Putting it all together: Example 1

Putting it all together: Example 2

Putting it all together: Example 3

❓QUIZ 7: IF and FOR Looping Statements

Do...Loops

Validating user input using a Do...Loop

Creating a guessing game using a Do...Loop

Assignment 2: Do-While loop and Do-Until loop

The GoTo Statement

Combining Macro Recording and VBA Statements

How to join 2 different Macros

❓QUIZ 8: Variable iteration loops

Manage Errors using On Error Statements

Step through a Subroutine or Function

Set Breakpoints in your Code

Verify output using the Immediate Window

Watch a Value in a Routine

❓QUIZ 9: Debugging your VBA Code

VBA R1C1 Style – Introduction

Overcoming Limitations of Recorded Macros

Demystifying Excel’s R1C1 Reference Style

The Cells property

The Resize property

Example 1: R1C1 style

Example 2: R1C1 style

PROJECT: Transfer Data From one Excel Worksheet to another

PROJECT: Create an Automated Data Entry Form using Macros

PROJECT: Create an Interactive Map using VBA & Macros

PROJECT: Highlight Active Row & Column

PROJECT: Add a confirmation dialog box with VBA IF statements

PROJECT: Prompting a user to select a worksheet and run a macro

PROJECT: How to Create Notifications-Reminders using VBA Code

PROJECT: How to create an Excel Animated Chart using VBA Code

PROJECT: Saving a Workbook before Closing

PROJECT: Closing All Workbooks at Once

PROJECT: Build a Random Sudoku Generator & Solver with VBA

VBA Tutorial (PDF)

Will Office Scripts replace VBA?