Skip to content

Latest commit

 

History

History
60 lines (40 loc) · 1.72 KB

Excel.ThreeDFormat.RotationX.md

File metadata and controls

60 lines (40 loc) · 1.72 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
ThreeDFormat.RotationX property (Excel)
vbaxl10.chm119014
vbaxl10.chm119014
Excel.ThreeDFormat.RotationX
e9866449-2d84-1e47-276b-69c2feec713c
05/17/2019
medium

ThreeDFormat.RotationX property (Excel)

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.

Syntax

expression.RotationX

expression A variable that represents a ThreeDFormat object.

Remarks

To set the rotation of the extruded shape around the y-axis, use the RotationY property.

To set the rotation of the extruded shape around the z-axis, use the Rotation property of the Shape object.

To change the direction of the extrusion's sweep path without rotating the front face of the extrusion, use the SetExtrusionDirection method.

Example

This example adds three identical extruded ovals to myDocument and sets their rotation around the x-axis to -30, 0, and 30 degrees, respectively.

Set myDocument = Worksheets(1) 
With myDocument.Shapes 
 With .AddShape(msoShapeOval, 30, 30, 50, 25).ThreeD 
 .Visible = True 
 .RotationX = -30 
 End With 
 With .AddShape(msoShapeOval, 30, 70, 50, 25).ThreeD 
 .Visible = True 
 .RotationX = 0 
 End With 
 With .AddShape(msoShapeOval, 30, 110, 50, 25).ThreeD 
 .Visible = True 
 .RotationX = 30 
 End With 
End With

[!includeSupport and feedback]