Variables declared with Dim at the module level are available to all procedures within the module. At the procedure level, variables are available only within the procedure.
Public
Used at module level to declare public variables and allocate storage space.
Variables declared using the Public statement are available to all procedures in all modules in all applications unless Option Private Module is in effect; in which case, the variables are public only within the project in which they reside.
CAUTION: The Public statement can't be used in a class module to declare a fixed-length string variable.
Private
Used at module level to declare private variables and allocate storage space.
Private variables are available only to the module in which they are declared.
Global
- this was found in some documentation, but it is unclear if it exists and what it does