Search notes:

Office Object Model: Excel - Shape

Methods and properties

adjustments
alternativeText
application
apply() Applies to the specified shape formatting that's been copied by pickUp()
autoShapeType
backgroundStyle
blackWhiteMode
bottomRightCell
callout
chart The chart object if the shape represents a chart (see shape types)
child msoTrue if the shape is a child-shape or if all shapes in a shape range are child shapes of the same parent. Otherwise, returns msoFalse or msoTriStateMixed .
connectionSiteCount
connector
connectorFormat
controlFormat
copy()
copyPicture()
creator
cut()
decorative
delete()
duplicate()
fill
flip()
formControlType
glow
graphicStyle
groupItems
hasChart
hasSmartArt
horizontalFlip
hyperlink
iD
incrementLeft()
incrementRotation()
incrementTop()
left, top, height and width Coordinates of the shape
line
linkFormat
lockAspectRatio
locked
model3D
name
nodes
oLEFormat
onAction
parent
parentGroup
pickUp()
pictureFormat
placement
reflection
rerouteConnections()
rotation
scaleHeight(), scaleWidth() Scales the shape's width/height be a given factor
select()
setShapesDefaultProperties()
shadow
shapeStyle
smartArt
softEdge
textEffect
textFrame
textFrame2
threeD
title
topLeftCell
type
ungroup()
verticalFlip
vertices
visible
zOrder()
zOrderPosition

Shape types

A shape is one of the following types:
More specifically, a type is indicated by the shape's .type property which is a value of the msoShapeType enumeration:
mso3DModel 30 3D model
msoAutoShape 1 AutoShape
msoCallout 2 Callout
msoCanvas 20 Canvas
msoChart 3 Chart
msoComment 4 Comment
msoContentApp 27 Content Office Add-in
msoDiagram 21 Diagram
msoEmbeddedOLEObject 7 Embedded OLE object
msoFormControl 8 Form control
msoFreeform 5 Freeform
msoGraphic 28 Graphic
msoGroup 6 Group
msoIgxGraphic 24 SmartArt graphic
msoInk 22 Ink
msoInkComment 23 Ink comment
msoLine 9 Line
msoLinked3DModel 31 Linked 3D model
msoLinkedGraphic 29 Linked graphic
msoLinkedOLEObject 10 Linked OLE object
msoLinkedPicture 11 Linked picture
msoMedia 16 Media
msoOLEControlObject 12 OLE control object
msoPicture 13 Picture
msoPlaceholder 14 Placeholder
msoScriptAnchor 18 Script anchor
msoShapeTypeMixed -2 Mixed shape type
msoTable 19 Table
msoTextBox 17 Text box
msoTextEffect 15 Text effect
msoWebVideo 26 Web video
TODO: If the shape is a chart, the chart has also a chart type

See also

shape objects are (among others?) returned by the various add… methods of the shapes collection.
The ShapeRange collection allows to work with multiple shape-objects at the same time.
The option drawingObjects of worksheet.protect

Index