ThreeDFormat Members (Excel)

Represents a shape's three-dimensional formatting.

Methods

Name	Description
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
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.