ThreeDFormat Object [Excel 2003 VBA Language Reference]
Multiple objects ThreeDFormat ColorFormat |
Represents a shape's three-dimensional formatting.
Using The ThreeDFormat Object
Use the ThreeD property 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
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.
Properties | Application Property | Creator Property | Depth Property | ExtrusionColor Property | ExtrusionColorType Property | Parent Property | Perspective Property | PresetExtrusionDirection Property | PresetLightingDirection Property | PresetLightingSoftness Property | PresetMaterial Property | PresetThreeDFormat Property | RotationX Property | RotationY Property | Visible Property
Methods | IncrementRotationX Method | IncrementRotationY Method | ResetRotation Method | SetExtrusionDirection Method | SetThreeDFormat Method
Parent Objects | Shape Object | ShapeRange Collection
Child Objects | ColorFormat Object