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

TopLeftCell Range

Type

MsoShape

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)

Was this article helpful?

+6 0
The Accidental Blogging Millionaires

The Accidental Blogging Millionaires

Get Inspired By The Most Popular Bloggers Online! If You Want To Skyrocket Your Success With Business And Improve Your Overall Life You Need To Have A Look At The Accidental Blogging Millionaires! Business can be a fight, particularly when you’re trying to establish one online and like all fights, to succeed you must find the winning techniques and apply them.

Get My Free Ebook


Responses

  • gimja
    How to shape read text vba?
    9 years ago

Post a comment