| Property Let Statement |
Named Arguments
No
Syntax
[Public | Private | Friend] [Static] Property Let name _
([arglist,] value)
[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 property procedure 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 within 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: Keyword
The name of the property.
arglist
Use: Required
Data Type: Any
A comma-delimited list of variables to be passed to the property as arguments from the calling procedure.
value
Use: Required
Type: Any
The last (or only) argument in arglist, being a variable containing the value 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 ...
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