FillFormat.PresetGradientType property (Excel)

Returns the preset gradient type for the specified fill. Read-only MsoPresetGradientType.



expression A variable that represents a FillFormat object.


Use the PresetGradient method to set the preset gradient type for the fill.


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

Set c1f = Charts(1).ChartArea.Fill 
If c1f.Type = msoFillGradient Then 
    With Charts(2).ChartArea.Fill 
        .Visible = True 
        .PresetGradient c1f.GradientStyle, _ 
            c1f.GradientVariant, c1f.PresetGradientType 
    End With 
End If

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.