ThreeDFormat.SetThreeDFormat method (Excel)
Sets the preset extrusion format. Each preset extrusion format contains a set of preset values for the various properties of the extrusion.
Syntax
expression.SetThreeDFormat (PresetThreeDFormat)
expression A variable that represents a ThreeDFormat object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| PresetThreeDFormat | Required | MsoPresetThreeDFormat | Specifies a preset extrusion format that corresponds to one of the options (numbered from left to right, from top to bottom) displayed when you choose the 3D button on the Drawing toolbar. |
Remarks
This method sets the PresetThreeDFormat property to the format specified by the PresetThreeDFormat argument.
Example
This example adds an oval to myDocument and sets its extrusion format to 3D Style 12.
Set myDocument = Worksheets(1)
With myDocument.Shapes.AddShape(msoShapeOval, _
30, 30, 50, 25).ThreeD
.Visible = True
.SetThreeDFormat msoThreeD12
End With
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.