Share via

ColorStop.ThemeColor Property

  • Article
Excel Developer Reference

Returns or sets the theme color of the represented object. Read/write

Version Information
 Version Added:  Excel 2007

Syntax

expression.ThemeColor

expression   A variable that represents a ColorStop object.

Return Value
Long

Remarks

Example
Applies theme color to the active selection.

Visual Basic for Applications 
  Range("A1:A10").Select
With Selection.Interior.Gradient.ColorStop.Add(1)
    .ThemeColor = xlThemeColorAccent1
    .TintAndShade = 0
End With

See Also