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?

+5 0

Responses

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

Post a comment