Edit

TextEffectFormat.PresetTextEffect property (Excel)

  • Article

Returns or sets the style of the specified WordArt. Read/write MsoPresetTextEffect.

Syntax

expression.PresetTextEffect

expression A variable that represents a TextEffectFormat object.

Remarks

The values for this property correspond to the formats in the WordArt Gallery dialog box (numbered from left to right, top to bottom).

Setting the PresetTextEffect property automatically sets many other formatting properties of the specified shape.

Example

This example sets the style for all WordArt on myDocument to the first style listed in the WordArt Gallery dialog box.

Set myDocument = Worksheets(1) 
For Each s In myDocument.Shapes 
 If s.Type = msoTextEffect Then 
 s.TextEffect.PresetTextEffect = msoTextEffect1 
 End If 
Next

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.