TextEffectFormat Members (Excel)

  • Article

Contains properties and methods that apply to WordArt objects.

Methods

Name

Description

ToggleVerticalText

Switches the text flow in the specified WordArt from horizontal to vertical, or vice versa.

Properties

Name

Description

Alignment

Returns or sets an MsoTextEffectAlignment value that represents the alignment for WordArt.

Application

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.

Creator

Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.

FontBold

True if the font in the specified WordArt is bold. Read/write MsoTriState.

FontItalic

Returns msoTrue if the font in the specified WordArt is italic. Read/write MsoTriState.

FontName

Returns or sets the name of the font in the specified WordArt. Read/write String.

FontSize

Returns or sets the font size for the specified WordArt, in points. Read/write Single.

KernedPairs

True if character pairs in the specified WordArt are kerned. Read/write MsoTriState.

NormalizedHeight

True if all characters (both uppercase and lowercase) in the specified WordArt are the same height. Read/write MsoTriState.

Parent

Returns the parent object for the specified object. Read-only.

PresetShape

Returns or sets the shape of the specified WordArt. Read/write MsoPresetTextEffectShape.

PresetTextEffect

Returns or sets the style of the specified WordArt. Read/write MsoPresetTextEffect.

RotatedChars

True if characters in the specified WordArt are rotated 90 degrees relative to the WordArt's bounding shape. False if characters in the specified WordArt retain their original orientation relative to the bounding shape. Read/write MsoTriState.

Text

Returns or sets the text for the specified object. Read/write String.

Tracking

Returns or sets the ratio of the horizontal space allotted to each character in the specified WordArt to the width of the character. Can be a value from 0 (zero) through 5. (Large values for this property specify ample space between characters; values less than 1 can produce character overlap.) Read/write Single.