Patterns Property (Format Object)

The Patterns property returns a single Pattern object or a Patterns collection belonging to this format. Read-only.

Syntax

Set objPatterns = objFormat.Patterns

Set objPattern = objFormat.Patterns(index)

objPatterns

Object. The Patterns collection of this format.

objFormat

Required. The Format object.

objPattern

Object. An individual Pattern object belonging to this format’s Patterns collection.

index

Integer. An index into the format’s Patterns collection.

Data Type

Object (Pattern or Patterns collection)

Remarks

Each pattern in the collection specifies rendering for a particular set of values of the property represented by the Format object.

If a Pattern object is to be accessed with the index parameter, the value of index must be between 1 and the size of the format’s Patterns collection. This size is available in the collection’s Count property.

Although the Patterns property itself is read-only, the collection it returns can be accessed in the normal manner through its Add method, and the properties on its member Pattern objects retain their respective read/write or read-only accessibility.