Alignment Property [Excel 2003 VBA Language Reference]

  • Article

Alignment property as it applies to the TextEffectFormat object.

MsoTextEffectAlignment

MsoTextEffectAlignment can be one of these MsoTextEffectAlignment constants.
msoTextEffectAlignmentCentered
msoTextEffectAlignmentLeft
msoTextEffectAlignmentLetterJustify
msoTextEffectAlignmentMixed
msoTextEffectAlignmentRight
msoTextEffectAlignmentStretchJustify
msoTextEffectAlignmentWordJustify

expression.Alignment

expression Required. An expression that returns one of the above objects.

Alignment property as it applies to the Phonetic, Phonetics, and TickLabels objects.

Returns or sets the alignment for the specified phonetic text or tick label. Read/write Long.

expression.Alignment

expression Required. An expression that returns one of the above objects.

Phoentic or Phonetics can be one of these XlPhoneticAlignment constants.
XlPhoneticAlignCenter
XlPhoneticAlignDistributed
XlPhoneticAlignLeft
XlPhoneticAlignNoControl
TickLabels can be one of these XlHAlign constants.
XlHAlignCenter
XlHAlignLeft
XlHAlignRight

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

Applies to | Phonetic Object | Phonetics Collection Object | TextEffectFormat Object | TickLabels Object