TextEffectFormat Object

Excel Developer Reference

Contains properties and methods that apply to WordArt objects.


Use the TextEffect property to return a TextEffectFormat object.


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