VB & VBA in a Nutshell: The Language

A.20. Variable Declaration

Const Statement

Declares a constant

Dim Statement

Declares a local variable at procedure level

Friend Statement

Declares the procedure or variable to have scope only in the project in which it is defined

Private Statement

Declares the procedure or variable to have scope only in the module in which it is defined

Public Statement

Declares a procedure or variable to have scope in the module and project in which it is defined and, if declared in an object module, to have scope outside the current project

ReDim Statement

Declares a dynamic array variable

Type...EndType Statement

Declares a user-defined type