Skip to content

Latest commit

 

History

History
49 lines (31 loc) · 1.13 KB

Excel.FillFormat.PresetGradientType.md

File metadata and controls

49 lines (31 loc) · 1.13 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
FillFormat.PresetGradientType property (Excel)
vbaxl10.chm115018
vbaxl10.chm115018
Excel.FillFormat.PresetGradientType
e9cb1ba6-9c40-3fef-7014-68069be4da1f
04/26/2019
medium

FillFormat.PresetGradientType property (Excel)

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

Syntax

expression.PresetGradientType

expression A variable that represents a FillFormat object.

Remarks

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

Example

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

[!includeSupport and feedback]