Important : Declaring multiple Variables with one Dim Statement

Hello friends,   As you know in VBA variables are declared using Dim Statement. You have also learnt about how to declare a variable in VBA in the previous articles. You have also learnt about Implicit and explicit option variables.   Here is a question: In below image there are two ways of declaring three variables VAR1, VAR2 and VAR3 [...]

VBA Programming : Variables in VBA

Just like other programming Languages, Excel VBA also uses different types of Variables. This Article teaches you following Topics:   1. What is Variable ? 2. Importance of Variable in Excel Programming 3. Important Rules of Variables, you must know, before declaring a Variable 4. Different Types of Variables 5. How to Declare / Initialize and Assign value to a [...]