FillFormat.OneColorGradient Method (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Sets the specified fill to a one-color gradient.

expression .OneColorGradient(Style, Variant, Degree)

expression A variable that represents a FillFormat object.

Parameters

Name

Required/Optional

Data Type

Description

Style

Required

MsoGradientStyle

The gradient style.

Variant

Required

Integer

The gradient variant. Can be a value from 1 through 4, corresponding to one of the four variants on the Gradient tab in the Fill Effects dialog box. If GradientStyle is msoGradientFromCenter, the Variant argument can only be 1 or 2.

Degree

Required

Single

The gradient degree. Can be a value from 0.0 (dark) through 1.0 (light).

Show: