VerticalFlip Property [Excel 2003 VBA Language Reference]

  • Article

MsoTriState

MsoTriState can be one of these MsoTriState constants.
msoCTrue
msoFalse
msoTriStateMixed
msoTriStateToggle
msoTrue The specified shape is flipped around the vertical axis.

expression.VerticalFlip

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

Example

This example restores each shape on myDocument to its original state if it's been flipped horizontally or vertically.

Set myDocument = Worksheets(1)
For Each s In myDocument.Shapes
    If s.HorizontalFlip Then s.Flip msoFlipHorizontal
    If s.VerticalFlip Then s.Flip msoFlipVertical
Next

Applies to | Shape Object | ShapeRange Collection