Pattern Property [Excel 2003 VBA Language Reference]
Pattern property as it applies to the LineFormat object.
MsoPatternType
MsoPatternType can be one of these MsoPatternType constants. |
msoPattern10Percent |
msoPattern20Percent |
msoPattern25Percent |
msoPattern30Percent |
msoPattern40Percent |
msoPattern50Percent |
msoPattern5Percent |
msoPattern60Percent |
msoPattern70Percent |
msoPattern75Percent |
msoPattern80Percent |
msoPattern90Percent |
msoPatternDarkDownwardDiagonal |
msoPatternDarkHorizontal |
msoPatternDarkUpwardDiagonal |
msoPatternDarkVertical |
msoPatternDashedDownwardDiagonal |
msoPatternDashedHorizontal |
msoPatternDashedUpwardDiagonal |
msoPatternDashedVertical |
msoPatternDiagonalBrick |
msoPatternDivot |
msoPatternDottedDiamond |
msoPatternDottedGrid |
msoPatternHorizontalBrick |
msoPatternLargeCheckerBoard |
msoPatternLargeConfetti |
msoPatternLargeGrid |
msoPatternLightDownwardDiagonal |
msoPatternLightHorizontal |
msoPatternLightUpwardDiagonal |
msoPatternLightVertical |
msoPatternMixed |
msoPatternNarrowHorizontal |
msoPatternNarrowVertical |
msoPatternOutlinedDiamond |
msoPatternPlaid |
msoPatternShingle |
msoPatternSmallCheckerBoard |
msoPatternSmallConfetti |
msoPatternSmallGrid |
msoPatternSolidDiamond |
msoPatternSphere |
msoPatternTrellis |
msoPatternWave |
msoPatternWeave |
msoPatternWideDownwardDiagonal |
msoPatternWideUpwardDiagonal |
msoPatternZigZag |
expression.Pattern
expression Required. An expression that returns one of the above objects.
Pattern property as it applies to the ChartFillFormat and FillFormat objects.
MsoPatternType
MsoPatternType can be one of these MsoPatternType constants. |
msoPattern10Percent |
msoPattern20Percent |
msoPattern25Percent |
msoPattern30Percent |
msoPattern40Percent |
msoPattern50Percent |
msoPattern5Percent |
msoPattern60Percent |
msoPattern70Percent |
msoPattern75Percent |
msoPattern80Percent |
msoPattern90Percent |
msoPatternDarkDownwardDiagonal |
msoPatternDarkHorizontal |
msoPatternDarkUpwardDiagonal |
msoPatternDarkVertical |
msoPatternDashedDownwardDiagonal |
msoPatternDashedHorizontal |
msoPatternDashedUpwardDiagonal |
msoPatternDashedVertical |
msoPatternDiagonalBrick |
msoPatternDivot |
msoPatternDottedDiamond |
msoPatternDottedGrid |
msoPatternHorizontalBrick |
msoPatternLargeCheckerBoard |
msoPatternLargeConfetti |
msoPatternLargeGrid |
msoPatternLightDownwardDiagonal |
msoPatternLightHorizontal |
msoPatternLightUpwardDiagonal |
msoPatternLightVertical |
msoPatternMixed |
msoPatternNarrowHorizontal |
msoPatternNarrowVertical |
msoPatternOutlinedDiamond |
msoPatternPlaid |
msoPatternShingle |
msoPatternSmallCheckerBoard |
msoPatternSmallConfetti |
msoPatternSmallGrid |
msoPatternSolidDiamond |
msoPatternSphere |
msoPatternTrellis |
msoPatternWave |
msoPatternWeave |
msoPatternWideDownwardDiagonal |
msoPatternWideUpwardDiagonal |
msoPatternZigZag |
expression.Pattern
expression Required. An expression that returns one of the above objects.
Remarks
Use the Patterned method to set the pattern type for the fill.
Pattern property as it applies to the Interior object.
xlPattern
xlPatternAutomatic |
xlPatternChecker |
xlPatternCrissCross |
xlPatternDown |
xlPatternGray16 |
xlPatternGray25 |
xlPatternGray50 |
xlPatternGray75 |
xlPatternGray8 |
xlPatternGrid |
xlPatternHorizontal |
xlPatternLightDown |
xlPatternLightHorizontal |
xlPatternLightUp |
xlPatternLightVertical |
xlPatternNone |
xlPatternSemiGray75 |
xlPatternSolid |
xlPatternUp |
xlPatternVertical |
expression.Pattern
expression Required. An expression that returns one of the above objects.
Example
This example adds a crisscross pattern to the interior of cell A1 on Sheet1.
Worksheets("Sheet1").Range("A1"). _
Interior.Pattern = xlPatternCrissCross
Applies to | ChartFillFormat Object | FillFormat Object | Interior Object | LineFormat Object
See Also | PatternColor Property