ForeColor Property

Returns or sets the foreground color for the specified object or area. When you set this property, you can use either a Long value representing a red-green-blue (RGB) color value or a String value representing 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 an RGB color value (for example, red is RGB(255,0,0)). Read/write Variant.

expression   Required. An expression that returns one of the objects in the Applies To list.

Remarks

This property always returns the color as a Long value representing an RGB color value.

Example

This example sets the font size, foreground color, and background color for the title bar in PivotTable1 .

Sub Format_Titlebar()
    Dim vwView
	
    Set vwView = PivotTable1.ActiveView
	
    ' Set the background color of the title bar.
    vwView.Label.BackColor = "DarkSalmon"
	
    ' Set the font size of the title bar.
    vwView.Label.Font.Size = 16
	
    ' Set the foreground color of the title bar.
    vwView.Label.ForeColor = "Sienna"
End Sub