Skip to content

Latest commit

 

History

History
50 lines (32 loc) · 1.19 KB

Excel.FillFormat.GradientDegree.md

File metadata and controls

50 lines (32 loc) · 1.19 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
FillFormat.GradientDegree property (Excel)
vbaxl10.chm115014
vbaxl10.chm115014
Excel.FillFormat.GradientDegree
46529845-6ee0-def7-8dac-bb459d6ed2f0
04/26/2019
medium

FillFormat.GradientDegree property (Excel)

Returns the gradient degree of the specified one-color shaded fill as a floating-point value from 0.0 (dark) through 1.0 (light). Read-only Single.

Syntax

expression.GradientDegree

expression A variable that represents a FillFormat object.

Remarks

This property is read-only. Use the OneColorGradient method to set the gradient degree 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 And _ 
 c1f.GradientColorType = msoGradientOneColor Then 
 With Charts(2).ChartArea.Fill 
 .Visible = True 
 .OneColorGradient c1f.GradientStyle, _ 
 c1f.GradientVariant, c1f.GradientDegree 
 End With 
End If

[!includeSupport and feedback]