Skip to content

Latest commit

 

History

History
55 lines (34 loc) · 1.59 KB

Excel.Shape.IncrementRotation.md

File metadata and controls

55 lines (34 loc) · 1.59 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Shape.IncrementRotation method (Excel)
vbaxl10.chm636079
vbaxl10.chm636079
Excel.Shape.IncrementRotation
3b9f1ae0-da53-b0e7-6569-dc3cd4595b12
05/14/2019
medium

Shape.IncrementRotation method (Excel)

Changes the rotation of the specified shape around the z-axis by the specified number of degrees. Use the Rotation property to set the absolute rotation of the shape.

Syntax

expression.IncrementRotation (Increment)

expression A variable that represents a Shape object.

Parameters

Name Required/Optional Data type Description
Increment Required Single Specifies how far the shape is to be rotated horizontally, in degrees. A positive value rotates the shape clockwise; a negative value rotates it counterclockwise.

Remarks

To rotate a three-dimensional shape around the x-axis or the y-axis, use the IncrementRotationX method or the IncrementRotationY method.

Example

This example duplicates shape one on myDocument, sets the fill for the duplicate, moves it 70 points to the right and 50 points up, and rotates it 30 degrees clockwise.

Set myDocument = Worksheets(1) 
With myDocument.Shapes(1).Duplicate 
 .Fill.PresetTextured msoTextureGranite 
 .IncrementLeft 70 
 .IncrementTop -50 
 .IncrementRotation 30 
End With

[!includeSupport and feedback]