0a86ac22-9496-d801-0cfb-a9fca5c30fec.md

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

See also

Concepts

TextEffectFormat Object

Other resources

TextEffectFormat Object Members