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

In order to view the rest of this content you will need to register for a premium account. Click here for your free trial.

As always, a site wouldn't be anything without its users so please feel free to comment! We welcome any comments you have on the material and any suggestions you may have for future content.


In our humble opinion, it is worth commenting just so you can play with Fun Captcha below!

Leave a Reply

Your email address will not be published. Required fields are marked *