Flip Method [Excel 2003 VBA Language Reference]

  • Article

Flips the specified shape around its horizontal or vertical axis.

expression.Flip(FlipCmd)

expression Required. An expression that returns one of the objects in the Applies To list.

MsoFlipCmd

MsoFlipCmd can be one of these MsoFlipCmd constants.
msoFlipHorizontal
msoFlipVertical

Example

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

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

Applies to | Shape Object | ShapeRange Collection