01 - The Range Object

1 Quiz

01 - Range Object Quiz

02 - Range Properties

VALUE, TEXT and FORMULA Properties - Reading and Writing Functions To a Cell

Row and Column Properties

SELECT Method

COUNT Property

Exercise 02a - Objectives Overview

Exercise 02a - Solution

ADDRESS Property

NUMBERFORMAT Property

FONT Collection - BOLD, ITALIC, UNDERLINE Properties

Exercise 02b - Objectives Overview

Exercise 02b - Solution

Add Color To Cells, Inside and Out (4 Ways)

Section 2 Quiz

1 Quiz

02 - Range Properties Quiz

03 - The Cells Object

Intro To The Cells Object

Using The Cells Object and Practical Applications

Using Column Letters Instead of Numbers

Using Cells Positionally Within A Range

Affecting ALL Cells In A Worksheet

Exercise 03 - Objectives Overview

Exercise 03 - Solution

Using Range Object With Cells Object (To Affect Multiple Cells)

1 Quiz

04 - Variables

Variable Declaration and Different Variable Types

Variable Type Demonstration

String Manipulation - Concatenation Examples

String Manipulation - Len, Left, Right Functions

String Manipulation - Mid Function (2 Methods)

String Manipulation - Replace Function

String Manipulation - Format Function

String Manipulation - InStr Function and Practice Projects

Date and Time Functions and Fun DateTime Math Tricks

CDate and DateDiff Functions

Exercise 04 - Objectives Overview

Exercise 04 - Solution

Scope and Heirarchy of Variables and Procedures

VARIABLE SCOPES - Public, Private and other Variables

Procedural Scopes - Public Versus Private Subs, Option Private Module

Using Constants

Passing Values to Another Procedure - ByRef vs ByVal

Section 4 Quiz

1 Quiz

04 - Variables Quiz

05 - Toolbars and Menus

File Menu Walkthrough

Edit Menu Walkthrough

View Menu Walkthrough Pt 1

View Menu Walkthrough Pt 2

Insert, Format and Debug Menu Walkthrough

Run and Tools Menu Walkthrough

Section 5 Quiz

1 Quiz

05 - Toolbars Quiz

06 - Super Important Tools and Excel Logic

Three Ways To Access Other Sheets - Sheet Name, Index and CodeName

Get the Last Row of Your Data Set

Get the Last (Rightmost) Column of Your Data Set

Get the Next Row in Your Data Set - Data Entry Basics

Recording a Macro 101

Dynamically Sorting The Employee Data

Absolute vs Relative References and OFFSET() Function

R1C1 Notation and How To Use In Formulas

Using Worksheet Functions in the VBE

Random Password Generator Assignment

Random Password Generator Solution Video

Using With and End With

If Then Statement

Using Is Not Equal To And The NOT Operator

AND, OR and NOT Operators

Exercise 06a - Objectives Overview

Exercise 06a - Solution

Using ELSE and ELSEIF Commands

Rock, Paper, Scissors Game Project Breakdown

Rock, Paper, Scissors Game Solution

The LIKE Operator

Compare Strings With Case Insensitivity Using UCase and LCase

Comparitive Operators With Text and Numbers (IsNumeric Function)

Two Ways to Use If Then Statements in a One-Liner of Code

Using GOTO and Labels, Common Uses, Error Routing

Select Case as Alternative to IF THEN Statements

Advanced MessageBox Features

User Interaction - Message Box with Yes, No Buttons

Exercise 06b - Objectives Overview

Exercise 06b - Solution

User Defined Functions 101

User Defined Functions - Optional Parameters

Volatile vs Non-Volatile Functions

Section 6 Quiz

1 Quiz

06 - Super Important Info Quiz

07 - Loops and Report Writing Basics

Intro To Loops

The FOR NEXT Loop

Fun With The FOR NEXT Loop

Beginning Our First Report Using Loops

How To Loop Through Each Character In A String Or Phrase

Morse Code Generator - Objectives Overview

Morse Code Generator - Solution

Increment Columns And Rows - Loops Within A Loop

How and When To Exit A Loop, Sub Or Function

Intro To User Interaction With An InputBox

Specialized InputBox Method to Prompt for Numbers, Ranges, Etc

More User Interaction Demos To Follow Along

Name Definition Game - Objectives Overview

Name Definition Game - Solution

Printable Report Part 1 - Getting Items On Report Sheet

Printable Report Part 2 - Clearing Last Report

Printable Report Part 3 - Ensuring Visibility and Autoselect Report Sheet

Seven Hacks To Massively Speed Up Your Code

Exercise 07a - Objectives Overview

Exercise 07a - Solution

Sending Reports To the Printer or Using Automatic Print Preview

The FOR EACH Loop

Intro To DO LOOPS

Help With Infinite Loops - INTERRUPTING A MACRO AND PHANTOM BREAKS

Do Loop - While and Until Operators

BONUS - Loop Through Multiple Files in a Folder and Scrape Data From Each

Exercise 07b - Objectives Overview

Exercise 07b - Solution

Section 7 Quiz

1 Quiz

07 - Loops and Reports Quiz

EVENTS: Worksheet Events made Easy

Intro To Events

Selection Change - Macros When You Change The Active Cell

Running Events Manually and Break Points

Worksheet Activate Event and Intro to Me Keyword

Worksheet Deactivate Event

BeforeDelete Event - for Worksheet Deletion

BeforeDoubleClick Event - Trigger a Macro When You Double Click

Excel Dialog Boxes

The Intersect Function - Test Whether Target Is Within a Range Of Cells

BeforeRightClick Event and Customizing Right Click Context Menu Pt 1

Customizing the Right Click Context Menu Pt 2 - Adding Custom Buttons

Exercise 08a - Objectives Overview

Exercise 08a - Solution

Worksheet Calculate Event

Worksheet Change Event and Preventing Endless Loops

Exercise 08b - Objectives Overview

Exercise 08b - Solution

FollowHyperlink Event

Final Thoughts on Worksheet Events and Review Other Events

Tic Tac Toe Game - Objectives Overview

Tic Tac Toe Game - Solution

Section 8 Quiz

1 Quiz

08 - Worksheet Events Quiz

WorkBook Events

Workbook Events Intro

1 of 2

Next Lesson

Intro and Course Files Download

The Ultimate Excel VBA Course 2.0 Intro and Course Files Download

Welcome! Please download the course files above in the 'Materials' tab☝️. Then watch this video to get started! 👇

Welcome to the FREE Preview. To get access to the downloadable files, please enroll in the course.

Back to Course

Next Lesson

2 Comments

Collapse Comments

Katherine Haynes August 23, 2022 at 7:56 pm

Looking forward to learning more. Will that background music be on all the time?

Dan Strong (Administrator) August 24, 2022 at 8:25 am

Hey Katherine, thanks for the feedback! The music is only for the intro video that showcases all the fun we're going to have!

The Ultimate Excel VBA Course 2.0

Intro and Course Files Download

Leave a Comment Click here to cancel reply.