FillFormat.PresetGradient method (Excel)

Sets the specified fill to a preset gradient.


expression.PresetGradient (Style, Variant, PresetGradientType)

expression A variable that represents a FillFormat object.


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 Style is msoGradientFromCenter, the Variant argument can only be 1 or 2.
PresetGradientType Required MsoPresetGradientType The preset gradient type.

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.