ThreeDFormat Object Members
| Excel Developer Reference |
Represents a shape's three-dimensional formatting.
Methods
| Name | Description | |
|---|---|---|
.gif "Bb225729.methods(en-us,office.12).gif") |
IncrementRotationHorizontal | Changes the rotation of the specified shape horizontally by the specified number of degrees. |
|
IncrementRotationVertical | Changes the rotation of the specified shape vertically by the specified number of degrees. |
|
IncrementRotationX | Changes the rotation of the specified shape around the x-axis by the specified number of degrees. Use the RotationX property to set the absolute rotation of the shape around the x-axis. |
|
IncrementRotationY | Changes the rotation of the specified shape around the y-axis by the specified number of degrees. Use the RotationY property to set the absolute rotation of the shape around the y-axis. |
|
IncrementRotationZ | Changes the rotation of the specified shape around the z-axis by the specified number of degrees. |
|
ResetRotation | Resets the extrusion rotation around the x-axis and the y-axis to 0 (zero) so that the front of the extrusion faces forward. This method doesn’t reset the rotation around the z-axis. |
|
SetExtrusionDirection | Sets the direction that the extrusion's sweep path takes away from the extruded shape. |
|
SetPresetCamera | Sets the camera for the specified ThreeDFormat object. |
|
SetThreeDFormat | Sets the preset extrusion format. Each preset extrusion format contains a set of preset values for the various properties of the extrusion. |
Properties
| Name | Description | |
|---|---|---|
.gif "Bb225729.properties(en-us,office.12).gif") |
Application | When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only. |
|
BevelBottomDepth | Returns or sets the bottom depth when using the bevel effect on a ThreeDFormat object. Read/write Single. |
|
BevelBottomInset | Returns or sets a value indicating whether the bottom insert bevel should be raised for a ThreeDFormat object. Read/write Single. |
|
BevelBottomType | Returns or sets the bottom bevel type for a ThreeDFormat object. Read/write MsoBevelType. |
|
BevelTopDepth | Returns or sets the top depth when using the bevel effect on a ThreeDFormat object. Read/write Single. |
|
BevelTopInset | Returns or sets a value indicating whether the top insert bevel should be raised for a ThreeDFormat object. Read/write Single. |
|
BevelTopType | Returns or sets the top Bevel type for a ThreeDFormat object. Read/write MsoBevelType. |
|
ContourColor | Returns the contour color for a ThreeDFormat object. Read-only ColorFormat. |
|
ContourWidth | Returns or sets the contour width for a ThreeDFormat object. Read/write Single. |
|
Creator | Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long. |
|
Depth | Returns or sets a Single value that represents the depth of the shape's extrusion. |
|
ExtrusionColor | Returns a ColorFormat object that represents the color of the shape's extrusion. Read-only. |
|
ExtrusionColorType | Returns or sets a value that indicates whether the extrusion color is based on the extruded shape’s fill (the front face of the extrusion) and automatically changes when the shape’s fill changes, or whether the extrusion color is independent of the shape’s fill. Read/write MsoExtrusionColorType. |
|
FieldOfView | Returns or sets the angle at which a ThreeDFormat object can be viewed. Read/write Single. |
|
LightAngle | Returns or sets the angel of the extrusion lights set on a ThreeDFormat object. Read/write Single. |
|
Parent | Returns the parent object for the specified object. Read-only. |
|
Perspective | Returns or sets an MsoTriState value that determines whether the extrusion appears in perspective. |
|
PresetCamera | Returns or sets the extrusion preset camera for a ThreeDFormat object. Read-only MsoPresetCamera. |
|
PresetExtrusionDirection | Returns the direction that the extrusion's sweep path takes away from the extruded shape (the front face of the extrusion). Read-only MsoPresetExtrusionDirection. |
|
PresetLighting | Returns or sets the extrusion preset lighting for a ThreeDFormat object. Read-only MsoLightRigType. |
|
PresetLightingDirection | Returns or sets the position of the light source relative to the extrusion. Read/write MsoPresetLightingDirection. |
|
PresetLightingSoftness | Returns or sets the intensity of the extrusion lighting. Read/write MsoPresetLightingSoftness. |
|
PresetMaterial | Returns or sets the extrusion surface material. Read/write MsoPresetMaterial. |
|
PresetThreeDFormat | Returns the preset extrusion format. Each preset extrusion format contains a set of preset values for the various properties of the extrusion. Read-only MsoPresetThreeDFormat. |
|
ProjectText | Returns or sets the project text state for the specified ThreeDFormat object. Read/write MsoTriState. |
|
RotationX | Returns or sets the rotation of the extruded shape around the x-axis in degrees. Can be a value from – 90 through 90. A positive value indicates upward rotation; a negative value indicates downward rotation. Read/write Single. |
|
RotationY | Returns or sets the rotation of the extruded shape around the y-axis in degrees. Can be a value from – 90 through 90. A positive value indicates rotation to the left; a negative value indicates rotation to the right. Read/write Single. |
|
RotationZ | Returns or sets the rotation of the extruded shape around the z-axis in degrees. Read/write Single. |
|
Visible | Returns or sets a MsoTriState value that determines whether the object is visible. Read/write. |
|
Z | Returns the Z order of the specified ThreeDFormat object. Read/write Single. |