The Ultimate Excel VBA Course 2.0

01 - The Range Object

Intro and Course Files Download Sample Lesson

Get The Developer Ribbon (PC and Mac) Sample Lesson

What Is The Range Object and Your First Macro From Scratch Sample Lesson

Adding Secondary or Subsequent Commands Sample Lesson

Debugging in Excel VBA and Stepping Through Code

Three Easy Ways To Test Or Store A Value

How and When To Record a Macro (Plus Clean Up Tips)

Three Main Data Type Notations For Entering Into Cells

Several Ways of Triggering Macros (Intro To Buttons and Fun Controls)

Exercise 01 - Objectives Overview

Exercise 01 - Solution

Affecting Multiple Cells With One Range Command

Using A Named Range With The Range Object

Tips and Best Practices For Better Development Skills

01 - Range Object Quiz

02 - Range Properties

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

Row and Column Properties

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)

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)

03 - Cells Quiz

04 - Variables

Intro To Variables

Math With Variables Sample Lesson

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

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

05 - Toolbars Quiz

06 - Super Important Tools and Excel Logic

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

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

06 - Super Important Info Quiz

07 - Loops and Report Writing Basics

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

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

08 - Worksheet Events Quiz

WorkBook Events

Workbook Events Intro

1 of 2

Previous Lesson

What Is The Range Object and Your First Macro From Scratch

The Ultimate Excel VBA Course 2.0
What Is The Range Object and Your First Macro From Scratch

Previous Lesson

Leave a Comment Click here to cancel reply.

You must be logged in to post a comment.

X

Username

Password

Remember me

Forgot Password?

Login

Accessing this course requires a login. Please enter your credentials below!

Username or Email Address

Password

Remember Me

Lost Your Password?

Register

Don't have an account? Register one!

Register an Account