ThreeDFormat object (Excel)

Represents a shape's three-dimensional formatting.

Remarks

You cannot apply three-dimensional formatting to some kinds of shapes, such as beveled shapes or multiple-disjoint paths. Most of the properties and methods of the ThreeDFormat object for such a shape will fail.

Example

Use the ThreeD property of the Shape object to return a ThreeDFormat object. The following example adds an oval to myDocument, and then specifies that the oval be extruded to a depth of 50 points and that the extrusion be purple.

Set myDocument = Worksheets(1) 
Set myShape = myDocument.Shapes.AddShape(msoShapeOval, _ 
 90, 90, 90, 40) 
With myShape.ThreeD 
 .Visible = True 
 .Depth = 50 
 .ExtrusionColor.RGB = RGB(255, 100, 255) 
 ' RGB value for purple 
End With

Methods

• IncrementRotationHorizontal
• IncrementRotationVertical
• IncrementRotationX
• IncrementRotationY
• IncrementRotationZ
• ResetRotation
• SetExtrusionDirection
• SetPresetCamera
• SetThreeDFormat

Properties

• Application
• BevelBottomDepth
• BevelBottomInset
• BevelBottomType
• BevelTopDepth
• BevelTopInset
• BevelTopType
• ContourColor
• ContourWidth
• Creator
• Depth
• ExtrusionColor
• ExtrusionColorType
• FieldOfView
• LightAngle
• Parent
• Perspective
• PresetCamera
• PresetExtrusionDirection
• PresetLighting
• PresetLightingDirection
• PresetLightingSoftness
• PresetMaterial
• PresetThreeDFormat
• ProjectText
• RotationX
• RotationY
• RotationZ
• Visible
• Z

See also

• Excel Object Model Reference

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.