Share via

FillFormat.GradientColorType Property

  • Article
Excel Developer Reference

Returns the gradient color type for the specified fill. Read-only MsoGradientColorType.

Syntax

expression.GradientColorType

expression   A variable that represents a FillFormat object.

Remarks

MsoGradientColorMixed is a return value only which indicates a combination of the other states in the specified range. Use the OneColorGradient, PresetGradient, or TwoColorGradient method to set the gradient type for the fill.

Example

This example sets the fill format for chart two to the same style used for chart one.

Visual Basic for Applications 
  Set c1f = Charts(1).ChartArea.Fill
If c1f.Type = msoFillGradient And _
        c1f.GradientColorType = msoGradientOneColor Then
    With Charts(2).ChartArea.Fill
        .Visible = True
        .OneColorGradient c1f.GradientStyle, _
            c1f.GradientVariant, c1f.GradientDegree
    End With
End If

See Also