ShapeRange Properties (Excel)
Contribute to this content Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation. |
Properties
Name |
Description |
---|---|
Returns an Adjustments object that contains adjustment values for all the adjustments in the specified shape. Applies to any ShapeRange object that represents an AutoShape, WordArt, or a connector. |
|
Returns or sets the descriptive (alternative) text string for a ShapeRange object when the object is saved to a Web page. Read/write String. |
|
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. |
|
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. |
|
Returns or sets the background style. Read/write MsoBackgroundStyleIndex. |
|
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. |
|
Returns a CalloutFormat object that contains callout formatting properties for the specified shape. Applies to a ShapeRange object that represent line callouts. Read-only. |
|
Returns a Chart object that represents the chart contained in the shape range. Read-only. |
|
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. |
|
Returns the number of connection sites on the specified shape. Read-only Long. |
|
True if the specified shape is a connector. Read-only MsoTriState. |
|
Returns a ConnectorFormat object that contains connector formatting properties. Applies to a ShapeRange objects that represent connectors. Read-only. |
|
Returns a Long value that represents the number of objects in the collection. |
|
Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long. |
|
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. |
|
Returns a GlowFormat object for a specified shape range that contains glow formatting properties for the shape range. Read-only. |
|
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 ShapeRange objects that represent grouped shapes. Read-only. |
|
Returns whether a shape range contains a chart. Read-only MsoTriState. |
|
Returns or sets a Single value that represents the height, in points, of the object. |
|
True if the specified shape is flipped around the horizontal axis. Read-only MsoTriState. |
|
Returns a Long value that represents the type for the specified object. |
|
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). |
|
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. |
|
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. |
|
Returns or sets a String value representing the name of the object. |
|
Returns a ShapeNodes collection that represents the geometric description of the specified shape. |
|
Returns the parent object for the specified object. Read-only. |
|
Returns a Shape object that represents the common parent shape of a child shape or a range of child shapes. |
|
Returns a PictureFormat object that contains picture formatting properties for the specified shape. Applies to a ShapeRange object that represent pictures or OLE objects. Read-only. |
|
Returns a ReflectionFormat object for a specified shape range that contains reflection formatting properties for the shape range. Read-only. |
|
Returns or sets the rotation of the shape, in degrees. Read/write Single. |
|
Returns a read-only ShadowFormat object that contains shadow formatting properties for the specified shape or shapes. |
|
Returns or sets an MsoShapeStyleIndex that represents shape style of shape range. Read/write. |
|
Returns a SoftEdgeFormat object for a specified shape range that contains soft edge formatting properties for the shape range. Read-only. |
|
Returns a TextEffectFormat object that contains text-effect formatting properties for the specified shape. Read-only. |
|
Returns a TextFrame object that contains the alignment and anchoring properties for the specified shape. Read-only. |
|
Returns a TextFrame2 object that contains text formatting for the specified shape range. Read-only. |
|
Returns a ThreeDFormat object that contains 3-D – effect formatting properties for the specified shape. Read-only. |
|
Returns or sets the title of the alternative text associated with the specified shape range. Read/write |
|
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. |
|
Returns a MsoShapeType value that represents the shape type. |
|
True if the specified shape is flipped around the vertical axis. Read-only MsoTriState. |
|
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. |
|
Returns or sets a MsoTriState value that determines whether the object is visible. Read/write. |
|
Returns or sets a Single value that represents the width, in points, of the object. |
|
Returns the position of the specified shape in the z-order. Read-only Long.Read-only |