Programming Reference Manual

Private Definition

 
Syntax
 
Private [WithEvents] name[type][([dim[, ...]])] [As [New] type][, ...]
 
Description
Create arrays (or simple variables) which are available to the entire macro/module, but not other macros/modules. Dimension var array(s) using the dims to establish the minimum and maximum index value for each dimension. If the dims are omitted then a scalar (single value) variable is defined. A dynamic array is declared using  without any dims. It must be ReDimensioned before it can be used.  The Private statement must be placed outside of Sub, Function or Property blocks.
See Also
Dim, Option Base, Public, ReDim, Static, WithEvents.
Example
 
Private A0,A1(1),A2(1,1)
 
Sub Init
    A0 = 1
    A1(0) = 2
    A2(0,0) = 3
End Sub
 
Sub Main
    Init
    Debug.Print A0;A1(0);A2(0,0) ' 1 2 3
End Sub