Syntax:
[ | Private | Public | Friend ] [ Default ] Property Get name[type][([param[, ...]])] [As type[()]]
End Property
-or-
[ | Private | Public | Friend ] Property [Let|Set] name[([param[, ...]])]
End Property
Group: Declaration
Description:
User defined property. The property defines a set of statements
to be executed when its value is used or changed. A property acts like
a variable, except that getting its value calls Property Get and changing
its value calls Property Let (or Property Set). Property Get and Property
Let with the same name define
a property that holds a value. Property Get and Property Set with the
same name define a property
that holds an object reference. The values of the calling arglist
are assigned to the params.
(For Property Let and Property Set the last parameter is the value on
the right hand side of the assignment operator.)
Property defaults to Public
if Private, Public
or Friend are not
is specified.
Example:
Dim X_Value
Property Get
X()
X = X_Value
End Property
Property Let
X(NewValue)
If Not IsNull(NewValue)
Then X_Value = NewValue
End Property
Sub
Main
X = "Hello"
Debug.Print
X
X = Null
Debug.Print
X
End Sub