Shapes.AddTextEffect method (Excel)

Article
09/13/2021

Creates a WordArt object. Returns a Shape object that represents the new WordArt object.

Syntax

expression.AddTextEffect (PresetTextEffect, Text, FontName, FontSize, FontBold, FontItalic, Left, Top)

expression A variable that represents a Shapes object.

Parameters

Name	Required/Optional	Data type	Description
PresetTextEffect	Required	MsoPresetTextEffect	The preset text effect.
Text	Required	String	The text in the WordArt.
FontName	Required	String	The name of the font used in the WordArt.
FontSize	Required	Single	The size (in points) of the font used in the WordArt.
FontBold	Required	MsoTriState	The font used in the WordArt to bold.
FontItalic	Required	MsoTriState	The font used in the WordArt to italic.
Left	Required	Single	The position (in points) of the upper-left corner of the WordArt's bounding box relative to the upper-left corner of the document.
Top	Required	Single	The position (in points) of the upper-left corner of the WordArt's bounding box relative to the top of the document.

Return value

Shape

Remarks

When you add WordArt to a document, the height and width of the WordArt are automatically set based on the size and amount of text that you specify.

Example

This example adds WordArt that contains the text Test to myDocument.

Set myDocument = Worksheets(1) 
Set newWordArt = myDocument.Shapes.AddTextEffect( _ 
    PresetTextEffect:=msoTextEffect1, Text:="Test", _ 
    FontName:="Arial Black", FontSize:=36, _ 
    FontBold:=msoFalse, FontItalic:=msoFalse, Left:=10, _ 
    Top:=10)

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.

Share via