|
Syntax |
Private name [(subscripts)] [As type] [,name [(subscripts)] [As type]]... |
|
|
Description |
Declares a list of private variables and their corresponding types and sizes. |
|
|
Comments |
Private variables are global to every Sub and Function within the currently executing script. If a type-declaration character is used when specifying name (such as %, @, &, $, or !), the optional [As type] expression is not allowed. For example, the following are allowed: Private foo As Integer The subscripts parameter allows the declaration of arrays. This parameter uses the following syntax: [lower To] upper [,[lower To] upper]... The lower and upper parameters are integers specifying the lower and upper bounds of the array. If lower is not specified, then the lower bound as specified by Option Base is used (or 1 if no Option Base statement has been encountered). Up to 60 array dimensions are allowed. |
|
|
|
The total size of an array (not counting space for strings) is limited to 64K. Dynamic arrays are declared by not specifying any bounds: Private a() The type parameter specifies the type of the data item being declared. It can be any of the following data types: String, Integer, Long, Single, Double, Currency, Object, data object, built-in data type, or any user-defined data type. If a variable is seen that has not been explicitly declared with either Dim, Public, or Private, then it will be implicitly declared local to the routine in which it is used. Fixed-Length Strings Fixed-length strings are declared by adding a length to the String type-declaration character: Private name As String * length where length is a literal number specifying the string's length. Initial Values All declared variables are given initial values, as described in the following table: |
|
|
|
Data Type |
Description |
|
|
Integer |
0 |
|
|
Long |
0 |
|
|
Double |
0.0 |
|
|
Single |
0.0 |
|
|
Currency |
0.0 |
|
|
Object |
Nothing |
|
|
Date |
December 31, 1899 00:00:00 |
|
|
Boolean |
False |
|
|
Variant |
Empty |
|
|
String |
"" (zero-length string) |
|
|
User-defined type |
Each element of the structure is given a default value, as described above. |
|
|
Arrays |
Each element of the array is given a default value, as described above. |
|
Example |
This example sets the value of variable x# in two separate routines to show the behavior of private variables. Private x# Sub Area() Sub Main() |
|
|
See Also |
Dim (statement); Redim (statement); Public (statement); Option Base (statement). |
|
|
|
P |
