VB & VBA in a Nutshell: The Language

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 ...