Category Archives: Data Types

All About Dim Statements in VBA

A variable is a named storage location in which you can store information while your macro/program is running.  Each variable has a unique name where the name can identify what type of variable it is by using standard naming conventions.  A variable can contain different

Entering a global variable

How Do Global Variables Work in VBA?

What is a Variable? When you are writing VBA code, you may need to store information at some point of your program that you may have need for at another point. For example, you may need to store the name of your company when you

No Thumbnail

VBA Converting Data Types

In this article I will explain how you can convert data types to one another. Jump To : String Conversions Convert String to a Numeric Data Type Check if String is Numeric, IsNumeric() Convert String to Integer, CInt() Convert String to Double, CDbl() Convert String to