Shape Members
Collapse the table of content
Expand the table of content
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here. ArchiveDisclaimer

Shape Members 

Represents an object in the drawing layer, such as an AutoShape, freeform, OLE object, or picture. The Shape object is a member of the Shapes collection. The Shapes collection contains all the shapes on a slide.

The following tables list the members exposed by the Shape type.

  Name Description
Adjustments Returns an Adjustments object that contains adjustment values for all the adjustments in the specified shape. Read-only.
AlternativeText Returns or sets the descriptive (alternative) text string for a Shape object when the object is saved to a Web page. Read/write String.
Application Returns an Application object that represents the Microsoft Excel application. Read-only.
AutoShapeType Returns or sets the shape type for the specified Shape object, which must represent an AutoShape other than a line, freeform drawing, or connector. Read/write Microsoft.Office.Core.MsoAutoShapeType.
BlackWhiteMode Returns or sets a value that indicates how the specified shape appears when the presentation is viewed in black-and-white mode. Read/write Microsoft.Office.Core.MsoBlackWhiteMode.
BottomRightCell Returns a Range object that represents the cell that lies under the lower-right corner of the object. Read-only.
Callout Returns a CalloutFormat object that contains callout formatting properties for the specified shape. Applies to Shape objects that represent line callouts. Read-only.
CanvasItems  
Child Returns msoTrue if the specified shape is a child shape or if all shapes in a shape range are child shapes of the same parent. Read-only Microsoft.Office.Core.MsoTriState.
ConnectionSiteCount Returns the number of connection sites on the specified shape. Read-only Integer.
Connector True if the specified shape is a connector. Read-only Microsoft.Office.Core.MsoTriState.
ConnectorFormat Returns a ConnectorFormat object that contains connector formatting properties. Applies to Shape objects that represent connectors. Read-only.
ControlFormat Returns a ControlFormat object that contains Microsoft Excel control properties. Read-only.
Creator Returns a 32-bit integer that indicates the application in which this object was created. If the object was created in Microsoft Excel, this property returns the string XCEL, which is equivalent to the hexadecimal number 5843454C. Read-only XlCreator.
Diagram Returns a Diagram object representing a diagram.
DiagramNode Returns a DiagramNode object that represents a node in a diagram.
DrawingObject  
Fill Returns a FillFormat object that contains fill formatting properties for the specified chart or shape. Read-only.
FormControlType Returns the Microsoft Excel control type. Read-only XlFormControl.
GroupItems Returns a GroupShapes object that represents the individual shapes in the specified group. Use the Item method of the GroupShapes object to return a single shape from the group. Applies to Shape objects that represent grouped shapes. Read-only.
HasDiagram Returns whether a shape or shape range contains a diagram. Read-only Microsoft.Office.Core.MsoTriState.
HasDiagramNode Returns a value indicating whether a diagram node exists in a given shape or shape range. Read-only Microsoft.Office.Core.MsoTriState.
Height The height of the object. Read/write Single.
HorizontalFlip True if the specified shape is flipped around the horizontal axis. Read-only Microsoft.Office.Core.MsoTriState.
Hyperlink Returns a Hyperlink object that represents the hyperlink for the shape.
ID Returns the type for the specified object. Read-only Integer.
Left The distance from the left edge of the object to the left edge of column A (on a worksheet) or the left edge of the chart area (on a chart). Read/write Single.
Line Returns a LineFormat object that contains line formatting properties for the specified shape. Read-only.
LinkFormat Returns a LinkFormat object that contains linked OLE object properties. Read-only.
LockAspectRatio True if the specified shape retains its original proportions when you resize it. False if you can change the height and width of the shape independently of one another when you resize it. Read/write Microsoft.Office.Core.MsoTriState.
Locked True if the object is locked, False if the object can be modified when the sheet is protected. Read/write Boolean.
Name Returns or sets the name of the object. Read/write String.
Nodes Returns a ShapeNodes collection that represents the geometric description of the specified shape. Applies to Shape objects that represent freeform drawings.
OLEFormat Returns an OLEFormat object that contains OLE object properties. Read-only.
OnAction Returns or sets the name of a macro that’s run when the specified object is clicked. Read/write String.
Parent Returns the parent object for the specified object. Read-only.
ParentGroup Returns a Shape object that represents the common parent shape of a child shape or a range of child shapes.
PictureFormat Returns a PictureFormat object that contains picture formatting properties for the specified shape. Applies to Shape objects that represent pictures or OLE objects. Read-only.
Placement Returns or sets the way the object is attached to the cells below it. Read/write XlPlacement.
Rotation Returns or sets the rotation of the shape in degrees. Read/write Single.
Script Returns the Script object, which represents a block of script or code on the specified Web page. If the page contains no script, nothing is returned.
Shadow True if the object has a shadow. Read/write Boolean.
TextEffect Returns a TextEffectFormat object that contains text-effect formatting properties for the specified shape. Applies to T:Microsoft.Office.Interop.Excel.Shape objects that represent WordArt. Read-only.
TextFrame Returns a TextFrame object that contains the alignment and anchoring properties for the specified shape. Read-only.
ThreeD Returns a ThreeDFormat object that contains 3-D – effect formatting properties for the specified shape. Read-only.
Top The distance from the top edge of the topmost shape in the shape range to the top edge of the worksheet. Read/write Single.
TopLeftCell Returns a Range object that represents the cell that lies under the upper-left corner of the specified object. Read-only.
Type Returns or sets the shape type. Read-only Microsoft.Office.Core.MsoShapeType.
VerticalFlip True if the specified shape is flipped around the vertical axis. Read-only Microsoft.Office.Core.MsoTriState.
Vertices Returns the coordinates of the specified freeform drawing's vertices (and control points for Bézier curves) as a series of coordinate pairs. Read-only Object.
Visible Determines whether the object is visible. Read/write Microsoft.Office.Core.MsoTriState.
Width The width of the object. Read/write Single.
ZOrderPosition Returns the position of the specified shape in the z-order. Read-only Integer.
Top

  Name Description
Apply Applies to the specified shape formatting that’s been copied by using the PickUp method.
CanvasCropBottom  
CanvasCropLeft  
CanvasCropRight  
CanvasCropTop  
Copy Copies the object to the Clipboard.
CopyPicture Copies the selected object to the Clipboard as a picture.
Cut Cuts the object to the Clipboard or pastes it into a specified destination.
Delete Deletes the object.
Duplicate Duplicates the object and returns a reference to the new copy.
Flip Flips the specified shape around its horizontal or vertical axis.
IncrementLeft Moves the specified shape horizontally by the specified number of points.
IncrementRotation Changes the rotation of the specified shape around the z-axis by the specified number of degrees. Use the Rotation property to set the absolute rotation of the shape.
IncrementTop Moves the specified shape vertically by the specified number of points.
PickUp Copies the formatting of the specified shape. Use the Apply method to apply the copied formatting to another shape.
RerouteConnections Reroutes connectors so that they take the shortest possible path between the shapes they connect.
ScaleHeight Scales the height of the shape by a specified factor.
ScaleWidth Scales the width of the shape by a specified factor.
Select Selects the object.
SetShapesDefaultProperties Makes the formatting of the specified shape the default formatting for the shape.
Ungroup Ungroups any grouped shapes in the specified shape or range of shapes. Disassembles pictures and OLE objects within the specified shape. Returns the ungrouped shapes as a single ShapeRange object.
ZOrder 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).
Top
Show:
© 2016 Microsoft