The main purpose of "Variables, Data Types and User-Defined Constants in Excel VBA" is to help you work with the following VBA constructs.
• Variables, including object variables.
• Data types.
• User-defined constants.
As you learn in "Variables, Data Types and User-Defined Constants in Excel VBA", variables/constants help you/Excel/VBA work more efficiently with data. Therefore, when you work with VBA, you are likely to often deal with variables/constants.
• Is part of my "VBA Fundamentals" Book Series; and
• Assumes you know about the topics covered in: (i) My previous Book Series, particularly in the "Excel Macros for Beginners" Book Series; and (ii) The previous Books in the "VBA Fundamentals" Book Series.
"Variables, Data Types and User-Defined Constants in Excel VBA" is divided in eight Chapters.
#1. Chapter 1 is an introduction to variables and data types.
#2. In Chapter 2, you learn to declare variables and data types.
#3. In Chapter 3, you learn about the main data types you can work with.
#4. In Chapter 4, you learn to assign data to variables.
#5. In Chapter 5, you learn about variable scope and lifetime.
#6. Chapter 6 contains several practical examples to help you understand/practice how to work with variables in VBA.
#7. In Chapter 7, you learn to work with object variables.
#8. In Chapter 8, you learn to work with user-defined constants.