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