Shape Object Members

  • Article
Excel Developer Reference

Represents an object in the drawing layer, such as an AutoShape, freeform, OLE object, or picture.

Methods

  Name Description
Bb225658.methods(en-us,office.12).gif Apply Applies to the specified shape formatting that’s been copied by using the PickUp method.
Bb225658.methods(en-us,office.12).gif Copy Copies the object to the Clipboard.
Bb225658.methods(en-us,office.12).gif CopyPicture Copies the selected object to the Clipboard as a picture.
Bb225658.methods(en-us,office.12).gif Cut Cuts the object to the Clipboard.
Bb225658.methods(en-us,office.12).gif Delete Deletes the object.
Bb225658.methods(en-us,office.12).gif Duplicate Duplicates the object and returns a reference to the new copy.
Bb225658.methods(en-us,office.12).gif Flip Flips the specified shape around its horizontal or vertical axis.
Bb225658.methods(en-us,office.12).gif IncrementLeft Moves the specified shape horizontally by the specified number of points.
Bb225658.methods(en-us,office.12).gif 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.
Bb225658.methods(en-us,office.12).gif IncrementTop Moves the specified shape vertically by the specified number of points.
Bb225658.methods(en-us,office.12).gif PickUp Copies the formatting of the specified shape. Use the Apply method to apply the copied formatting to another shape.
Bb225658.methods(en-us,office.12).gif RerouteConnections This method reroutes all connectors attached to the specified shape; if the specified shape is a connector, it’s rerouted.
Bb225658.methods(en-us,office.12).gif ScaleHeight Scales the height of the shape by a specified factor. For pictures and OLE objects, you can indicate whether you want to scale the shape relative to the original or the current size. Shapes other than pictures and OLE objects are always scaled relative to their current height.
Bb225658.methods(en-us,office.12).gif ScaleWidth Scales the width of the shape by a specified factor. For pictures and OLE objects, you can indicate whether you want to scale the shape relative to the original or the current size. Shapes other than pictures and OLE objects are always scaled relative to their current width.
Bb225658.methods(en-us,office.12).gif Select Selects the object.
Bb225658.methods(en-us,office.12).gif SetShapesDefaultProperties Makes the formatting of the specified shape the default formatting for the shape.
Bb225658.methods(en-us,office.12).gif Ungroup Ungroups any grouped shapes in the specified shape or range of shapes. Disassembles pictures and OLE objects within the specified shape or range of shapes.
Bb225658.methods(en-us,office.12).gif 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).

Properties

  Name Description
Bb225658.properties(en-us,office.12).gif Adjustments Returns an Adjustments object that contains adjustment values for all the adjustments in the specified shape. Applies to any Shape object that represents an AutoShape, WordArt, or a connector.
Bb225658.properties(en-us,office.12).gif 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.
Bb225658.properties(en-us,office.12).gif Application When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.
Bb225658.properties(en-us,office.12).gif AutoShapeType Returns or sets the shape type for the specified Shape or ShapeRange object, which must represent an AutoShape other than a line, freeform drawing, or connector. Read/write MsoAutoShapeType.
Bb225658.properties(en-us,office.12).gif BackgroundStyle Read/write
Bb225658.properties(en-us,office.12).gif 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 MsoBlackWhiteMode.
Bb225658.properties(en-us,office.12).gif BottomRightCell Returns a Range object that represents the cell that lies under the lower-right corner of the object. Read-only.
Bb225658.properties(en-us,office.12).gif Callout Returns a CalloutFormat object that contains callout formatting properties for the specified shape. Applies to a Shape object that represent line callouts. Read-only.
Bb225658.properties(en-us,office.12).gif Chart Read-only
Bb225658.properties(en-us,office.12).gif 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 MsoTriState.
Bb225658.properties(en-us,office.12).gif ConnectionSiteCount Returns the number of connection sites on the specified shape. Read-only Long.
Bb225658.properties(en-us,office.12).gif Connector True if the specified shape is a connector. Read-only MsoTriState.
Bb225658.properties(en-us,office.12).gif ConnectorFormat Returns a ConnectorFormat object that contains connector formatting properties. Applies to a Shape that represent connectors. Read-only.
Bb225658.properties(en-us,office.12).gif ControlFormat Returns a ControlFormat object that contains Microsoft Excel control properties. Read-only.
Bb225658.properties(en-us,office.12).gif Fill Returns a FillFormat object for a specified shape or a ChartFillFormat object for a specified chart that contains fill formatting properties for the shape or chart. Read-only.
Bb225658.properties(en-us,office.12).gif FormControlType Returns the Microsoft Excel control type. Read-only XlFormControl.
Bb225658.properties(en-us,office.12).gif Glow Read-only
Bb225658.properties(en-us,office.12).gif 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.
Bb225658.properties(en-us,office.12).gif HasChart Read-only
Bb225658.properties(en-us,office.12).gif Height Returns or sets a Single value that represents the height, in points, of the object.
Bb225658.properties(en-us,office.12).gif HorizontalFlip True if the specified shape is flipped around the horizontal axis. Read-only MsoTriState.
Bb225658.properties(en-us,office.12).gif Hyperlink Returns a Hyperlink object that represents the hyperlink for the shape.
Bb225658.properties(en-us,office.12).gif ID Returns a Long value that represents the type for the specified object.
Bb225658.properties(en-us,office.12).gif Left Returns or sets a Single value that represents the distance, in points, 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).
Bb225658.properties(en-us,office.12).gif Line Returns a LineFormat object that contains line formatting properties for the specified shape. (For a line, the LineFormat object represents the line itself; for a shape with a border, the LineFormat object represents the border). Read-only.
Bb225658.properties(en-us,office.12).gif LinkFormat Returns a LinkFormat object that contains linked OLE object properties. Read-only.
Bb225658.properties(en-us,office.12).gif 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 MsoTriState.
Bb225658.properties(en-us,office.12).gif Locked Returns or sets a Boolean value that indicates if the object is locked.
Bb225658.properties(en-us,office.12).gif Name Returns or sets a String value representing the name of the object.
Bb225658.properties(en-us,office.12).gif Nodes Returns a ShapeNodes collection that represents the geometric description of the specified shape.
Bb225658.properties(en-us,office.12).gif OLEFormat Returns an OLEFormat object that contains OLE object properties. Read-only.
Bb225658.properties(en-us,office.12).gif OnAction Returns or sets the name of a macro that’s run when the specified object is clicked. Read/write String.
Bb225658.properties(en-us,office.12).gif Parent Returns the parent object for the specified object. Read-only.
Bb225658.properties(en-us,office.12).gif ParentGroup Returns a Shape object that represents the common parent shape of a child shape or a range of child shapes.
Bb225658.properties(en-us,office.12).gif PictureFormat Returns a PictureFormat object that contains picture formatting properties for the specified shape. Applies to a Shape object that represent pictures or OLE objects. Read-only.
Bb225658.properties(en-us,office.12).gif Placement Returns or sets an XlPlacement value that represents the way the object is attached to the cells below it.
Bb225658.properties(en-us,office.12).gif Reflection Read-only
Bb225658.properties(en-us,office.12).gif Rotation Returns or sets the rotation of the shape, in degrees. Read/write Single.
Bb225658.properties(en-us,office.12).gif 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.
Bb225658.properties(en-us,office.12).gif Shadow Returns a read-only ShadowFormat object that contains shadow formatting properties for the specified shape or shapes.
Bb225658.properties(en-us,office.12).gif ShapeStyle Read/write
Bb225658.properties(en-us,office.12).gif SoftEdge Read-only
Bb225658.properties(en-us,office.12).gif TextEffect Returns a TextEffectFormat object that contains text-effect formatting properties for the specified shape. Read-only.
Bb225658.properties(en-us,office.12).gif TextFrame Returns a TextFrame object that contains the alignment and anchoring properties for the specified shape. Read-only.
Bb225658.properties(en-us,office.12).gif TextFrame2 Read-only
Bb225658.properties(en-us,office.12).gif ThreeD Returns a ThreeDFormat object that contains 3-D – effect formatting properties for the specified shape. Read-only.
Bb225658.properties(en-us,office.12).gif Top Returns or sets a Single value that represents the distance, in points, from the top edge of the topmost shape in the shape range to the top edge of the worksheet.
Bb225658.properties(en-us,office.12).gif TopLeftCell Returns a Range object that represents the cell that lies under the upper-left corner of the specified object. Read-only.
Bb225658.properties(en-us,office.12).gif Type Returns or sets a MsoShapeType value that represents the shape type.
Bb225658.properties(en-us,office.12).gif VerticalFlip True if the specified shape is flipped around the vertical axis. Read-only MsoTriState.
Bb225658.properties(en-us,office.12).gif Vertices Returns the coordinates of the specified freeform drawing's vertices (and control points for Bézier curves) as a series of coordinate pairs. You can use the array returned by this property as an argument to the AddCurve method or AddPolyLine method. Read-only Variant.
Bb225658.properties(en-us,office.12).gif Visible Returns or sets a MsoTriState value that determines whether the object is visible. Read/write.
Bb225658.properties(en-us,office.12).gif Width Returns or sets a Single value that represents the width, in points, of the object.
Bb225658.properties(en-us,office.12).gif ZOrderPosition Returns the position of the specified shape in the z-order. Read-only Long.Read-only