Excel.ThreeDFormat.RotationY.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
ThreeDFormat.RotationY property (Excel)	vbaxl10.chm119015	vbaxl10.chm119015	Excel.ThreeDFormat.RotationY	71d6e255-eb1c-62bc-61f2-8b4f8be3ad6f	05/17/2019	medium

ThreeDFormat.RotationY property (Excel)

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.

Syntax

expression.RotationY

expression A variable that represents a ThreeDFormat object.

Remarks

To set the rotation of the extruded shape around the x-axis, use the RotationX 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 y-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 
 .RotationY = -30 
 End With 
 With .AddShape(msoShapeOval, 30, 70, 50, 25).ThreeD 
 .Visible = True 
 .RotationY = 0 
 End With 
 With .AddShape(msoShapeOval, 30, 110, 50, 25).ThreeD 
 .Visible = True 
 .RotationY = 30 
 End With 
End With

[!includeSupport and feedback]