3.1 Properties

Right-click on the label, and select “Properties” (this should be the last item of the pop-up menu). The “Property Sheet” should be displayed now, usually on the right hand side.

A “property” is particular value that is associated with an individual object. For example, “Caption” is a property of a label, and every label can have a different value for its caption (from the other labels). Programmatically speaking, VBA code has access to most (but not all) of the properties accessible by the “Property Sheet” window.

For example, the “Name” property of a label (or any object) is not accessible in VBA code.

The “Property Sheet” is divided into tabs to help you locate a property quickly. Click “Format” to see all the properties related to the formatting of a label.

You can see that there is a large number of properties related to a seemingly simple and static object! If you change a property in the “Property Sheet”, the label in the form reflects that change immediately.

Note that most properties can be accessed in VBA code. For example, if the name of a label is Label1, then the “visible” property can be accessed as Label1.visible. Many properties can appear on the left hand side of an assignment statement so that they can be changed via VBA code.