Share via

Color Property

  • Article

Returns or sets the primary color of the specified object. Read/write Variant.

Remarks

When you set this property, you can use either a Long value representing a red-green-blue color value or a String value naming a valid HTML color value. For example, to set the object color to red, you could use the hexadecimal value &HFF, the decimal value 255, or the string value "red." In Microsoft Visual Basic, you can use the RGB function to create a red-green-blue color value (red is RGB(255,0,0)).

This property always returns the color as a Long value representing a red-green-blue color value.

On charts, you can also use either of the following two special constants: chColorAutomatic (to reset the color to the default value) or chColorNone (to indicate no color, or transparency). However, you cannot set a font color to chColorNone.

Example

This example adds a medium-weight green border to all cells in the range B5:C10 on the spreadsheet.

  Sub SetBorder()

  Set ssConstants = Spreadsheet1.Constants

    Spreadsheet1.ActiveSheet.Range("b5:c10").Borders.Weight = ssConstants.owcLineWeightMedium
    Spreadsheet1.ActiveSheet.Range("b5:c10").Borders.Color = "green"
End Sub