Share via

ThreeDFormat.SetThreeDFormat Method (Excel)

  • Article

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 click the 3-D 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

See Also

Concepts

ThreeDFormat Object Members

ThreeDFormat Object