ColorStop Object (Excel)

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

Version Added: Excel 2007

The ColorStop object enables you to set properties for the cell fill including the Color, ThemeColor, and TintAndShade properties.

The following example shows how to apply properties to a ColorStop object.

.

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:
© 2014 Microsoft