What does DIM mean in VBA code?

Answer by  akjoshi (15)

Dim keyword in VB is used to declare a variable and allocate memory; you need to provide the type of variable and a name for it- Dim myName as String You can declare and initialize the variables in same line too- Dim myName as String = "abhi" You can also declare arrays using dim keyword- Dim names() As String

Answer by  BrokenWits (382)

In VBA code, DIM is a reserved keyword that is used to declare a variable. That variable will then be used to store values, and used later in the code in order to help achieve the purpose of the program, and provide some sort of value needed later on in the code.