ZOrder Method

Applies To

Shape object, ShapeRange collection object.

Description

Moves the specified shape in front of or behind other shapes in the collection (that is, changes the shape's position in the z-order).

Syntax

expression.ZOrder(ZOrderCmd)

expression Required. An expression that returns a Shape or ShapeRange object.

ZOrderCmd Required Long. Specifies where to move the specified shape relative to the other shapes. Can be one of the following MsoZOrderCmd constants: msoBringForward, msoBringToFront, msoSendBackward, or msoSendToBack. The constants msoBringInFrontOfText and msoSendBehindText are used only in Microsoft Word.

Remarks

Use the ZOrderPosition property to determine a shape's current position in the z-order.

Example

This example adds an oval to myDocument and then places the oval second from the back in the z-order if there is at least one other shape on the document.

Set myDocument = Worksheets(1)
With myDocument.Shapes.AddShape(msoShapeOval, 100, 100, 100, 300)
    While .ZOrderPosition > 2
        .ZOrder msoSendBackward
    Wend
End With