Tag Archives: Data Types

VBA Naming Conventions: Best Practices

In any programming language it is quite natural for you to use several variables and objects to develop code. Throughout this process, you might get confused referencing them for the first time or reusing them for the second time. For example, you might create a

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

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