Skip to content

Latest commit

 

History

History
51 lines (30 loc) · 1.95 KB

Excel.ThreeDFormat.IncrementRotationX.md

File metadata and controls

51 lines (30 loc) · 1.95 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
ThreeDFormat.IncrementRotationX method (Excel)
vbaxl10.chm119020
vbaxl10.chm119020
Excel.ThreeDFormat.IncrementRotationX
599f96ca-6a8a-3b9e-5d76-c053f3236522
05/17/2019
medium

ThreeDFormat.IncrementRotationX method (Excel)

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.

Syntax

expression.IncrementRotationX (Increment)

expression A variable that represents a ThreeDFormat object.

Parameters

Name Required/Optional Data type Description
Increment Required Single Specifies how much (in degrees) the rotation of the shape around the x-axis is to be changed. Can be a value from -90 through 90. A positive value tilts the shape up; a negative value tilts it down.

Remarks

You cannot adjust the specified shape's rotation around the x-axis past the upper or lower limit for the RotationX property (90 degrees to -90 degrees). For example, if the RotationX property is initially set to 80 and you specify 40 for the Increment argument, the resulting rotation will be 90 (the upper limit for the RotationX property) instead of 120.

To change the rotation of a shape around the y-axis, use the IncrementRotationY method. To change the rotation around the z-axis, use the IncrementRotationZ method.

Example

This example tilts shape one on myDocument up 10 degrees. Shape one must be an extruded shape for you to see the effect of this code.

Set myDocument = Worksheets(1) 
myDocument.Shapes(1).ThreeD.IncrementRotationX 10

[!includeSupport and feedback]