Pattern Property

Applies To

ChartFillFormat object, FillFormat object, Interior object, LineFormat object.

Description

Interior object: Returns or sets the interior pattern. Read/write Long.

Can be one of the following XlPattern constants:

  • xlPatternAutomatic
  • xlPatternChecker
  • xlPatternCrissCross
  • xlPatternDown
  • xlPatternGray8
  • xlPatternGray16
  • xlPatternGray25
  • xlPatternGray50
  • xlPatternGray75
  • xlPatternGrid
  • xlPatternHorizontal
  • xlPatternLightDown
  • xlPatternLightHorizontal
  • xlPatternLightUp
  • xlPatternLightVertical
  • xlPatternNone
  • xlPatternSemiGray75
  • xlPatternSolid
  • xlPatternUp
  • xlPatternVertical

FillFormat object: Returns or sets the fill pattern. Read-only Long.

Can be one of the following MsoPatternType constants:

  • msoPattern10Percent
  • msoPattern20Percent
  • msoPattern25Percent
  • msoPattern30Percent
  • msoPattern40Percent
  • msoPattern50Percent
  • msoPattern5Percent
  • msoPattern60Percent
  • msoPattern70Percent
  • msoPattern75Percent
  • msoPattern80Percent
  • msoPattern90Percent
  • msoPatternDarkDownwardDiagonal
  • msoPatternDarkHorizontal
  • msoPatternDarkUpwardDiagonal
  • msoPatternDarkVertical
  • msoPatternDashedDownwardDiagonal
  • msoPatternDashedHorizontal

  • msoPatternDashedUpwardDiagonal
  • msoPatternDashedVertical
  • msoPatternDiagonalBrick
  • msoPatternDivits
  • msoPatternDottedGrid
  • msoPatternHorizontalBrick
  • msoPatternLargeCheckerBoard
  • msoPatternLargeConfetti
  • msoPatternLargeGrid
  • msoPatternLightDiamonds
  • msoPatternLightDownwardDiagonal
  • msoPatternLightHorizontal
  • msoPatternLightUpwardDiagonal
  • msoPatternLightVertical
  • msoPatternMixed
  • msoPatternNarrowHorizontal
  • msoPatternNarrowVertical
  • msoPatternOutlinedDiamonds
  • msoPatternPlaid
  • msoPatternShingles
  • msoPatternSmallCheckerBoard
  • msoPatternSmallConfetti
  • msoPatternSmallGrid
  • msoPatternSolidDiamonds
  • msoPatternSpheres
  • msoPatternTrellis
  • msoPatternWaves
  • msoPatternWavyLines
  • msoPatternWeave
  • msoPatternWideDownwardDiagonal
  • msoPatternWideUpwardDiagonal

See Also

PatternColor property.

Example

This example adds a crisscross pattern to the interior of cell A1 on Sheet1.

Worksheets("Sheet1").Range("A1").Interior.Pattern = xlPatternCrissCross