| Property Set Statement |
Named Arguments
No
Syntax
[Public | Private | Friend] [Static] Property Set name _
([arglist,] reference)
[statements]
[Exit Property]
[statements]
End Property
Public
Use: Optional
Type: Keyword
Gives the property scope through all procedures in all modules in the project. If used within a createable class module, the function is also accessible from outside the project. Public, Private, and Friend are mutually exclusive.
Private
Use: Optional
Type: Keyword
Restricts the scope of the property to those procedures in the same module. Public, Private, and Friend are mutually exclusive.
Friend
Use: Optional
Type: Keyword
Only valid within a class module; gives the property scope to all modules within a project, but not to modules outside the project. Public, Private, and Friend are mutually exclusive.
Static
Use: Optional
Type: Keyword
Preserves the value of all private variables declared inside the property between calls to the property.
name
Use: Required
Type: Any
The name of the property.
arglist
Use: Required
A comma-delimited list of variables to be passed to the property as arguments from the calling procedure.
reference
Use: Required
Type: Object
The last (or only) argument in arglist, which is a variable containing the object reference to be assigned to the property.
statements
Use: Optional
Program code to be executed within the property.
arglist uses the following syntax and parts:
[Optional] [ByVal | ByRef] [ParamArray] varname[( )] _ [As type
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access