In this article I am simply going to show you the different 'scopes' a variable can have. The 'scope' defines the range of the variable (ie where it can be accessed from)
Dim
Variables declared with Dim in the general declarations section in a form or module are available to all procedures within the module or form. If declared in a procedure the variables are available only within the procedure. For example:
Dim gVar As String
This variable will only be available in the module, form or procedure it is declared in.
Public
Variables declared using the Public statement are available to all procedures in all modules and forms. If you declare a variable as public in a module, you can change it by using this syntax:
VariableName = Value
However, if you declare the variable as public in a form, you need to specify the form too:
FormName.VariableName = Value
Private
Private variables are available only to the module or form in which they are declared. Variables cannot be declared as Private inside a procedure.
That's it!
Comments