ShapeRange.Flip Method

  • Article
Excel Developer Reference

Flips the specified shape around its horizontal or vertical axis.

Syntax

expression.Flip(FlipCmd)

expression   A variable that represents a ShapeRange object.

Parameters

Name Required/Optional Data Type Description
FlipCmd Required MsoFlipCmd Specifies whether the shape is to be flipped horizontally or vertically.

Example

This example adds a triangle to myDocument, duplicates the triangle, and then flips the duplicate triangle vertically and makes it red.

Visual Basic for Applications 
  Set myDocument = Worksheets(1)
With myDocument.Shapes.AddShape(msoShapeRightTriangle, _
        10, 10, 50, 50).Duplicate
    .Fill.ForeColor.RGB = RGB(255, 0, 0)
    .Flip msoFlipVertical
End With

See Also