Private Definition

Syntax

Private [WithEvents] name[type][([dim[, ...]])] [As [New] type][, ...]

Group

Declaration

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