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