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

02 Variables in Excel VBA

Current Status

Not Enrolled

Price

$20.00

Get Started

Course Content

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
Variables Quiz 1 Quiz
Lesson Content

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