TextEffectFormat.Alignment Property (Excel)
Returns or sets an MsoTextEffectAlignment value that represents the alignment for WordArt.
Syntax
expression .Alignment
expression A variable that represents a TextEffectFormat object.
Example
This example adds a WordArt object to worksheet one and then right aligns the WordArt.
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