Share via

ShapeRange.ZOrder Method

  • Article
Excel Developer Reference

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   A variable that represents a ShapeRange object.

Parameters

Name Required/Optional Data Type Description
ZOrderCmd Required MsoZOrderCmd Specifies where to move the specified shape relative to the other shapes.

Remarks

MsoZOrderCmd can be one of these MsoZOrderCmd constants.
msoBringForward
msoBringInFrontOfText. Used only in Microsoft Word.
msoBringToFront
msoSendBackward
msoSendBehindText. Used only in Microsoft Word.
msoSendToBack

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.

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

See Also