Have Questions? 
help@excelvbaisfun.com
Excel Ninja Pro
All Access

The Ultimate Excel VBA Course 2.0

Current Status

Not Enrolled

Price

$99.00

Get Started

Course Content

01 - The Range Object
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
Section 1 Quiz 1 Quiz
02 - Range Properties
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
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)
Section 3 Quiz 1 Quiz
Lesson Content
04 - Variables
Intro To 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
Lesson Content
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
Lesson Content
06 - Super Important Tools and Excel Logic
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
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
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
Exercise 07b - Objectives Overview
Exercise 07b - Solution
Section 7 Quiz 1 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
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
WorkBook Events
Workbook Events Intro
1 of 2

Excel VBA Is Fun

We believe Excel is one of the most versatile programs out there - and learning to program and automate it makes you very valuable!

You can prevent wasted time and errors, speed up tasks and become indispensable to your organization. 

See how our trainees have gotten raises, promotions and bonuses using their Excel Automation skills while building real problem-solving programs in Excel!
LEARN MORE
Copyright © 2025 ExcelVbaIsFun
X

Forgot Password?

Join Us

linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram