Share via

ThreeDFormat.PresetExtrusionDirection Property

  • Article
Excel Developer Reference

Returns the direction that the extrusion's sweep path takes away from the extruded shape (the front face of the extrusion). Read-only MsoPresetExtrusionDirection.

Syntax

expression.PresetExtrusionDirection

expression   A variable that represents a ThreeDFormat object.

Remarks

MsoPresetExtrusionDirection can be one of these MsoPresetExtrusionDirection constants.
msoExtrusionTop
msoExtrusionTopRight
msoExtrusionBottom
msoExtrusionBottomLeft
msoExtrusionBottomRight
msoExtrusionLeft
msoExtrusionNone
msoExtrusionRight
msoExtrusionTopLeft
msoPresetExtrusionDirectionMixed

This property is read-only. To set the value of this property, use the SetExtrusionDirection method.

Example

This example changes each extrusion on myDocument that extends toward the upper-left corner of the extrusion’s front face to an extrusion that extends toward the lower-right corner of the front face.

Visual Basic for Applications 
  Set myDocument = Worksheets(1)
For Each s In myDocument.Shapes
    With s.ThreeD
        If .PresetExtrusionDirection = msoExtrusionTopLeft Then
            .SetExtrusionDirection msoExtrusionBottomRight
        End If
    End With
Next

See Also