Variables || Excel VBA Master Class || 3.1
Start learning the components of the VBA programming language with an introduction to variables. Variables make our code more readable and at times, more efficient.
We will start with a practical introduction to variables. We will discuss a scenario involving data variables, constants and object variables. Rest of the lesson will focus on data variables.
Then, we will learn how to create variables using declaration and assignment statements.
Next, we will look at the properties of variables:
1. Name - Mandatory Rules and Suggestions
2. Data Types
3. Values - What are the default values for each data type?
4. Scope and visibility
#vba #excel
Follow the rest of the series, in the below playlist:
• VBA MasterClass
Code snippets can be found here:
https://skillsandautomation.com/maste...
00:00 Intro
00:44 Practical Introduction
06:11 Creating Variables
08:44 Property 1: Name
10:50 Property 2: Data Type
17:20 Property 3: Value
19:07 Property 4: Scope
