ColorStop Object
Collapse the table of content
Expand the table of content
This documentation is archived and is not being maintained.

ColorStop Object

Office 2007
Represents the color stop point for a gradient fill in an range or selection.

Version Information
 Version Added:  Excel 2007

Remarks

The ColorStop collection allows you to set properties for the cell fill including Color, ThemeColor, TintAndShade.

Example
The following example shows how to apply properties to the ColorStop.

Visual Basic for Applications
With Selection.Interior
    .Pattern = xlPatternLinearGradient
    .Gradient.Degree = 135
    .Gradient.ColorStops.Clear
End With

With Selection.Interior.Gradient.ColorStops.Add(0)
    .ThemeColor = xlThemeColorDark1
    .TintAndShade = 0
End With

With Selection.Interior.Gradient.ColorStops.Add(0.5)
    .ThemeColor = xlThemeColorAccent1
    .TintAndShade = 0
End With

With Selection.Interior.Gradient.ColorStops.Add(1)
    .ThemeColor = xlThemeColorDark1
    .TintAndShade = 0
End With



Show:
© 2016 Microsoft