Edit

CommandButton.Gradient property (Access)

  • Article

Gets or sets the gradient fill applied to the specified object. Read/write Long.

Syntax

expression.Gradient

expression A variable that represents a CommandButton object.

Remarks

The Gradient property contains a numeric expression that represents the gradient fill applied to the specified object. The default value of the Gradient property is 0, which does not apply a gradient. The values are listed in the following table.

Value Gradient fill
0 None
1 Linear Diagonal - Top Left to Bottom Right, Light
2 Linear Down, Light
3 Linear Diagonal - Top Right to Bottom Left, Light
4 From Bottom Right Corner, Light
5 From Bottom Left Corner, Light
6 Linear Left, Light
7 Linear Center, Light
8 Linear Right, Light
9 From Top Right Corner, Light
10 From Top Left Corner, Light
11 Linear Diagonal - Bottom Left to Top Right, Light
12 Linear Up, Light
13 Linear Diagonal - Bottom Right to Top Left, Light
14 Linear Diagonal - Top Left to Bottom Right, Dark
15 Linear Down, Dark
16 Linear Diagonal - Top Right to Bottom Left, Dark
17 From Bottom Right Corner, Dark
18 From Bottom Left Corner, Dark
19 Linear Left, Dark
20 Linear Center, Dark
21 Linear Right, Dark
22 From Top Right Corner, Dark
23 From Top Left Corner, Dark
24 Linear Diagonal - Bottom Left to Top Right, Dark
25 Linear Up, Dark
26 Linear Diagonal - Bottom Right to Top Left, Light

To see the available gradient fills and apply a gradient through the user interface, first open the form or report in Layout view or Design view by right-clicking the form or report in the navigation pane, and then choosing the view that you want.

Next, choose the object to which you want to apply a gradient fill. On the Format tab, in the Control Formatting group, choose Shape Fill > Gradient, and then choose a gradient fill. You can hover over a gradient fill to see a description.

This property is not surfaced in the property sheet.

Example

The following code example sets the gradient fill to Linear Down, Light.

Me.ctl.Gradient = 2

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.