Shape Properties
|
Name |
Returns |
Description |
|
Adjustments |
Adjustments |
Read-only. An object accessing the adjustments for a shape |
|
AlternativeText |
String |
Set/Get the alternate text to appear if the image is not loaded. Used with a web page |
|
AutoShapeType |
MsoAuto ShapeType |
Set/Get the type of AutoShape used |
|
BackgroundStyle |
MsoBackground StyleIndex |
Set/Get an MsoBackgroundStyleIndex constant representing the background style |
|
BlackWhite Mode |
MsoBlack WhiteMode |
Property used for compatibility with other drawing packages only. Does not do anything |
|
BottomRight Cell |
Range |
Read-only. Returns the single cell range that describes the cell under the lower-right corner of the shape |
|
Name |
Returns |
Description |
|
Callout |
Callout Format |
Read-only. An object accessing the callout properties of the shape |
|
Chart |
Chart |
Read-only. Returns the chart object contained in a given shape |
|
Child |
MsoTriState |
Read-only. Returns whether the specified shape is a child shape, or if all shapes in a shape range are child shapes of the same parent |
|
Connection SiteCount |
Long |
Read-only. Returns the number of potential connection points (sites) on the shape for a connector |
|
Connector |
MsoTriState |
Read-only. Returns whether the shape is a connector |
|
Connector Format |
Connector Format |
Read-only. Returns an object containing formatting options for a connector shape. Shape must be a connector shape |
|
ControlFormat |
Control Format |
Read-only. Returns an object containing formatting options for an Excel control. Shape must be an Excel control |
|
Diagram |
Diagram |
Read-only. Returns a Diagram object |
|
DiagramNode |
DiagramNode |
Read-only. Returns a node in the diagram |
|
Fill |
FillFormat |
Read-only. Returns an object containing fill formatting options for the Shape object |
|
FormControl Type |
XlForm Control |
Read-only. Returns the type of Excel control the current shape is (for example, xlCheck Box). Shape must be an Excel control |
|
Glow |
GlowFormat |
Read-only. Returns the glow formatting properties through the GlowFormat object |
|
GroupItems |
GroupShapes |
Read-only. Returns the shapes that make up the current shape |
|
HasChart |
MsoTriState |
Read-only. Returns whether a shape or shape range contains a chart |
|
Height |
Single |
Set/Get the height of the shape |
|
Horizontal Flip |
MsoTriState |
Read-only. Returns whether the shape has been flipped |
|
Hyperlink |
Hyperlink |
Read-only. Returns the hyperlink of the shape, if any |
|
ID |
Long |
Read-only. Returns the type for the specified object |
|
Left |
Single |
Set/Get the horizontal position of the shape |
|
Line |
LineFormat |
Read-only. An object accessing the line formatting of the shape |
|
Name |
Returns |
Description |
|
LinkFormat |
LinkFormat |
Read-only. An object accessing the OLE linking properties |
|
LockAspect Ratio |
MsoTriState |
Set/Get whether the dimensional proportions of the shape are kept when the shape is resized |
|
Locked |
Boolean |
Set/Get whether the shape can be modified if the sheet is locked (True = cannot modify) |
|
Name |
String |
Set/Get the name of the Shape object |
|
Nodes |
ShapeNodes |
Read-only. An object accessing the nodes of the freeform shape |
|
OLEFormat |
OLEFormat |
Read-only. An object accessing OLE object properties, if applicable |
|
OnAction |
String |
Set/Get the macro to run when the shape is clicked |
|
ParentGroup |
Shape |
Read-only. Returns the common parent shape of a child shape or a range of child shapes |
|
PictureFormat |
Picture Format |
Read-only. An object accessing the picture format options |
|
Placement |
XlPlacement |
Set/Get how the object will react with the cells around the shape |
|
Reflection |
Reflection Format |
Read-only. Returns the reflection formatting properties through the ReflectionFormat object |
|
Rotation |
Single |
Set/Get the degrees rotation of the shape |
|
Script |
Script |
Read-only. Returns the VBScript associated with the shape |
|
Shadow |
Shadow Format |
Read-only. An object accessing the shadow properties |
|
ShapeStyle |
MsoShapte StyleIndex |
Set/Get an MsoShapteStyleIndex constant representing the shape style of the Shape object |
|
SoftEdge |
SoftEdge Format |
Read-only. Returns the SoftEdge formatting properties through the SoftEdgeFormat object |
|
TextEffect |
TextEffect Format |
Read-only. An object accessing the text effect properties |
|
TextFrame |
TextFrame |
Read-only. An object accessing the text frame properties |
|
TextFrame2 |
TextFrame2 |
Read-only. An object accessing the text frame properties |
|
ThreeD |
ThreeD Format |
Read-only. An object accessing the 3D effect formatting properties |
|
Top |
Single |
Set/Get the vertical position of the shape |
Name Returns Description
|
Type | |
|
Type | |
|
VerticalFlip |
MsoTriState |
|
Vertices |
Variant |
|
Visible |
MsoTriState |
|
Width |
Single |
|
ZOrder |
Long |
|
Position |
Read-only. Returns the single cell range that describes the cell over the upper-left corner of the shape
Read-only. Returns the type of shape
Read-only. Returns whether the shape has been vertically flipped
Read-only. Returns a series of coordinate pairs describing the Freeform's vertices
Set/Get whether the shape is visible
Set/Get the width of the shape
Read-only. Returns where the shape is in the ZOrder of the collection (for example, front, back)
Post a comment