Interior.PatternColorIndex property (Word)
Returns or sets the color of the interior pattern as an index into the current color palette, or as one of the following XlColorIndex constants: xlColorIndexAutomatic or xlColorIndexNone. Read/write Long.
expression A variable that represents an 'Interior' object.
Set this property to xlColorIndexAutomatic to specify the automatic fill style for drawing objects. Set this property to xlColorIndexNone to specify that you do not want a pattern (this is the same as setting the Pattern property of the Interior object to xlPatternNone).
The following example enables up and down bars, then adds a criss-cross pattern to the down bars and sets the pattern color to red, for the first chart group of the first chart in the active document.
With ActiveDocument.InlineShapes(1) If .HasChart Then With .Chart.ChartGroups(1) .HasUpDownBars = True .DownBars.Interior.Pattern = xlPatternCrissCross .DownBars.Interior.PatternColorIndex = 3 End With End If End With
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.