Skip to content

02 Variables in Excel VBA

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

Previous Lesson

Math With Variables

02 Variables in Excel VBA
Math With Variables

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