Shape.ThreeD Property

  • Article
Excel Developer Reference

Returns a ThreeDFormat object that contains 3-D – effect formatting properties for the specified shape. Read-only.

Syntax

expression.ThreeD

expression   A variable that represents a Shape object.

Example

This example sets the depth, extrusion color, extrusion direction, and lighting direction for the 3-D effects applied to shape one on myDocument.

Visual Basic for Applications 
  Set myDocument = Worksheets(1)
With myDocument.Shapes(1).ThreeD
    .Visible = True
    .Depth = 50
    .ExtrusionColor.RGB = RGB(255, 100, 255)
    ' RGB value for purple
    .SetExtrusionDirection msoExtrusionTop
    .PresetLightingDirection = msoLightingLeft
End With

See Also