Flip Method

Microsoft Excel Visual Basic

Flip Method

       

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.

FlipCmd  Required MsoFlipCmd.  Specifies whether the shape is to be flipped horizontally or vertically

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