Private Statement

Declares private variables and allocates storage space. Declares, in a Class block, a private variable.

                      Private varname[([subscripts])][, varname[([subscripts])]] . . .

Arguments

  • varname
    Name of the variable; follows standard variable naming conventions.

  • subscripts
    Dimensions of an array variable; up to 60 multiple dimensions may be declared. The subscripts argument uses the following syntax:

    upper [, upper] . . .

    The lower bound of an array is always zero.

Remarks

Private statement variables are available only to the script in which they are declared.

A variable that refers to an object must be assigned an existing object using the Set statement before it can be used. Until it is assigned an object, the declared object variable is initialized as Empty.

You can also use the Private statement with empty parentheses to declare a dynamic array. After declaring a dynamic array, use the ReDim statement within a procedure to define the number of dimensions and elements in the array. If you try to redeclare a dimension for an array variable whose size was explicitly specified in a Private, Public, or Dim statement, an error occurs.

Note

When you use the Private statement in a procedure, you generally put the Private statement at the beginning of the procedure.

The following example illustrates use of the Private statement.

                      Private MyNumber   ' Private Variant variable.
Private MyArray(9)   ' Private array variable.
   ' Multiple Private declarations of Variant variables.
Private MyNumber, MyVar, YourNumber

Requirements

Version 1

See Also

Reference

Dim Statement

Public Statement

ReDim Statement

Set Statement

Array Function

IsArray Function

LBound Function

UBound Function

Erase Statement