03 – Data Types, Variables, Constants and Operators

In this post, we will be examining Data Types, Variables, Constants and Operators. Working with differing types of data is an essential skill in VBA and one that is necessary in order to write efficient code.

List of topics covered:

• Variables
• Declaring variables
• Dim
• Restrictions on naming variables
• Naming Conventions
• Constants
• Variable Scope
• Arithmetic Operators
• Common Errors
• Data Types
• Data types and definition
• Boolean – (Yes/No)
• Integer
• Long
• Single
• Double
• Currency
• Date
• String
• Variant

Downloadable Content

Code Examples VBA Fundamentals

PDF

Videos

Database Functions

Custom Functions

Related Posts