Edit

Share via

TextEffectFormat.PresetShape property (Excel)

  • Article

Returns or sets the shape of the specified WordArt. Read/write MsoPresetTextEffectShape.

Syntax

expression.PresetShape

expression A variable that represents a TextEffectFormat object.

Remarks

Setting the PresetTextEffect property automatically sets the PresetShape property.

Example

This example sets the shape of all WordArt on myDocument to a chevron whose center points down.

Set myDocument = Worksheets(1) 
For Each s In myDocument.Shapes 
 If s.Type = msoTextEffect Then 
 s.TextEffect.PresetShape = msoTextEffectShapeChevronDown 
 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.