Intro to Data Types || Excel VBA Master Class || 3.4a
Data Types are a fundamental concept of programming. Understanding data types is important to maintain the integrity of data that we intend to manipulate via our VBA code.
In this introductory lesson,
we will start with an overview of the Data Types that are available for us to use within VBA.
Then, we will disambiguate the terms Variable, Data Types, Values and Literals.
We will learn how to determine the type of a Value. Here, we will use the VarType Function & TypeOf Operator.
Next, we will check out how to convert data from one type to another. This is called Type Conversion and is an important topic.
And, lastly, we will distinguish between the terms used to describe values that represent no values, such as Nothing, Blank, Empty, Null etc.
The are 5 more parts to this lesson. In each part, we will dive into the ways of working with one particular group of Data Types.
#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
01:10 Overview of Data Types
02:15 Data Types, Values, Literals, Variables
04:22 Checking Types
07:23 Type Conversion
12:22 Default Values