Class ThreeDFormat (Excel VBA)

The class ThreeDFormat represents a shape's three-dimensional formatting.

The classes ChartFormat, Shape and TextFrame2. give access to class ThreeDFormat

Methods

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. Use the RotationZ property to set the absolute rotation of the shape around the z-axis.

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

BevelBottomDepth returns or sets the bottom depth when using the bevel effect on a ThreeDFormat object.

BevelBottomInset returns or sets a value indicating whether the bottom insert bevel should be raised for a ThreeDFormat object.

BevelBottomType returns or sets the bottom bevel type for a ThreeDFormat object.

BevelTopDepth returns or sets the top depth when using the bevel effect on a ThreeDFormat object.

BevelTopInset returns or sets a value indicating whether the top insert bevel should be raised for a ThreeDFormat object.

BevelTopType returns or sets the top bevel type for a ThreeDFormat object.

ContourColor returns the contour color for a ThreeDFormat object.

ContourWidth returns or sets the contour width for a ThreeDFormat object.

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.

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.

FieldOfView returns or sets the angle at which a ThreeDFormat object can be viewed.

LightAngle returns or sets the angle of the extrusion lights set on a ThreeDFormat object.

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.

PresetExtrusionDirection returns the direction that the extrusion's sweep path takes away from the extruded shape (the front face of the extrusion).

PresetLighting returns or sets the extrusion preset lighting for a ThreeDFormat object.

PresetLightingDirection returns or sets the position of the light source relative to the extrusion.

PresetLightingSoftness returns or sets the intensity of the extrusion lighting.

PresetMaterial returns or sets the extrusion surface material.

PresetThreeDFormat returns the preset extrusion format. Each preset extrusion format contains a set of preset values for the various properties of the extrusion.

ProjectText returns or sets the project text state for the specified ThreeDFormat object.

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.

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.

RotationZ returns or sets the rotation of the extruded shape around the z-axis in degrees. Can be a value from -90 through 90. A positive value indicates upward rotation; a negative value indicates downward rotation.

Visible returns or sets an MsoTriState value that determines whether the object is visible.

Z returns the Z order of the specified ThreeDFormat object.

ColorFormat - Represents the color of a one-color object, the foreground or background color of an object with a gradient or patterned fill, or the pointer color.