TextEffectFormat.Alignment Property

Excel Developer Reference

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



expression   A variable that represents a TextEffectFormat object.


This example adds a WordArt object to worksheet one and then right aligns the WordArt.

Visual Basic for Applications
  Set mySh = Worksheets(1).Shapes
Set myTE = mySh.AddTextEffect(PresetTextEffect:=msoTextEffect1, _
    Text:="Test Text", FontName:="Palatino", FontSize:=54, _
    FontBold:=True, FontItalic:=False, Left:=100, Top:=50)
myTE.TextEffect.Alignment = msoTextEffectAlignmentRight

See Also