Skip to content

Latest commit

 

History

History
53 lines (33 loc) · 1.34 KB

Excel.ShapeRange.ZOrder.md

File metadata and controls

53 lines (33 loc) · 1.34 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
ShapeRange.ZOrder method (Excel)
vbaxl10.chm640095
vbaxl10.chm640095
Excel.ShapeRange.ZOrder
3a2e8556-ddbf-312d-85a3-6cd5d2865499
05/14/2019
medium

ShapeRange.ZOrder method (Excel)

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

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

[!includeSupport and feedback]