TextEffectFormat Object

  • Article
Excel Developer Reference

Contains properties and methods that apply to WordArt objects.

Remarks

Use the TextEffect property to return a TextEffectFormat object.

Example

The following example sets the font name and formatting for shape one on myDocument. For this example to work, shape one must be a WordArt object.

Visual Basic for Applications 
  Set myDocument = Worksheets(1)
With myDocument.Shapes(1).TextEffect
    .FontName = "Courier New"
    .FontBold = True
    .FontItalic = True
End With

See Also