Excel VBA教程:Pattern属性

应用于 LineFormat对象的 Pattern属性。

返回或设置填充图案。MsoPatternType 类型,可读写。

MsoPatternType 可为以下 MsoPatternType 常量之一。
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   必需。该表达式返回上述对象之一。

 

应用于 ChartFillFormat 和 FillFormat对象的 Pattern属性。

返回或设置填充图案。MsoPatternType 类型,只读。

MsoPatternType 可为以下 MsoPatternType 常量之一。
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   必需。该表达式返回上述对象之一。

 

应用于 Interior对象的 Pattern属性。

返回或者设置内部图案。Variant 类型,可读写。

expression.Pattern

expression   必需。该表达式返回上述对象之一。

 

示例

本示例为 Sheet1 中 A1 单元格的内部添加十字图案。


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

上页:Excel VBA教程:PathSeparator属性 下页:Excel VBA教程:PatternColor属性

Excel VBA教程:Pattern属性

Excel VBA教程:PatternColor属性 Excel VBA教程:PatternColorIndex属性
Excel VBA教程:Period属性 Excel VBA教程:PersonalViewListSettings属性
Excel VBA教程:PersonalViewPrintSettings属性 Excel VBA教程:Perspective属性
Excel VBA教程:Phonetic属性 Excel VBA教程:PhoneticCharacters属性
Excel VBA教程:Phonetics属性 Excel VBA教程:PictureFormat属性
Excel VBA教程:PictureType属性 Excel VBA教程:PictureUnit属性
Excel VBA教程:Pie3DGroup属性 Excel VBA教程:PivotCell属性
Excel VBA教程:PivotCellType属性 Excel VBA教程:PivotField属性
Excel VBA教程:PivotFields属性 Excel VBA教程:PivotFormulas属性
Excel VBA教程:PivotItem属性 Excel VBA教程:PivotLayout属性
版权所有 © 中山市飞娥软件工作室 证书:粤ICP备09170368号