ThreeDFormat.SetExtrusionDirection Method (Excel)
Sets the direction that the extrusion's sweep path takes away from the extruded shape.
Syntax
expression .SetExtrusionDirection(PresetExtrusionDirection)
expression A variable that represents a ThreeDFormat object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
PresetExtrusionDirection |
Required |
Specifies the extrusion direction. |
Remarks
MsoPresetExtrusionDirection can be one of these MsoPresetExtrusionDirection constants. |
msoExtrusionBottom |
msoExtrusionBottomLeft |
msoExtrusionBottomRight |
msoExtrusionLeft |
msoExtrusionNone |
msoExtrusionRight |
msoExtrusionTop |
msoExtrusionTopLeft |
msoExtrusionTopRight |
msoPresetExtrusionDirectionMixed |
This method sets the PresetExtrusionDirection property to the direction specified by the PresetExtrusionDirection argument.
Example
This example specifies that the extrusion for shape one on myDocument extend toward the top of the shape and that the lighting for the extrusion come from the left.
Set myDocument = Worksheets(1)
With myDocument.Shapes(1).ThreeD
.Visible = True
.SetExtrusionDirection msoExtrusionTop
.PresetLightingDirection = msoLightingLeft
End With