Share via

ThreeDFormat.Depth Property

  • Article
Excel Developer Reference

Returns or sets a Single value that represents the depth of the shape's extrusion.

Syntax

expression.Depth

expression   A variable that represents a ThreeDFormat object.

Remarks

The value of this property can be a value from –600 through 9600 (positive values produce an extrusion whose front face is the original shape; negative values produce an extrusion whose back face is the original shape).

Example

This example adds an oval to myDocument and then specifies that the oval be extruded to a depth of 50 points and that the extrusion be purple.

Visual Basic for Applications 
  Set myDocument = Worksheets(1)
Set myShape = myDocument.Shapes.AddShape(msoShapeOval, _
    90, 90, 90, 40)
With myShape.ThreeD
    .Visible = True
    .Depth = 50
    ' RGB value for purple
    .ExtrusionColor.RGB = RGB(255, 100, 255)
End With

See Also