Skip to content

Latest commit

 

History

History
49 lines (32 loc) · 1.25 KB

Excel.Shape.IncrementLeft.md

File metadata and controls

49 lines (32 loc) · 1.25 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Shape.IncrementLeft method (Excel)
vbaxl10.chm636078
vbaxl10.chm636078
Excel.Shape.IncrementLeft
2e9081f0-c11a-7c42-486e-53cb32d6d99c
05/14/2019
medium

Shape.IncrementLeft method (Excel)

Moves the specified shape horizontally by the specified number of points.

Syntax

expression.IncrementLeft (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 moved horizontally, in points. A positive value moves the shape to the right; a negative value moves it to the left.

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]