Shapes.AddTextEffect Method

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

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Function AddTextEffect ( _
    PresetTextEffect As MsoPresetTextEffect, _
    Text As String, _
    FontName As String, _
    FontSize As Single, _
    FontBold As MsoTriState, _
    FontItalic As MsoTriState, _
    Left As Single, _
    Top As Single _
) As Shape
'Usage
Dim instance As Shapes
Dim PresetTextEffect As MsoPresetTextEffect
Dim Text As String
Dim FontName As String
Dim FontSize As Single
Dim FontBold As MsoTriState
Dim FontItalic As MsoTriState
Dim Left As Single
Dim Top As Single
Dim returnValue As Shape

returnValue = instance.AddTextEffect(PresetTextEffect, _
    Text, FontName, FontSize, FontBold, _
    FontItalic, Left, Top)

Shape AddTextEffect(
    MsoPresetTextEffect PresetTextEffect,
    string Text,
    string FontName,
    float FontSize,
    MsoTriState FontBold,
    MsoTriState FontItalic,
    float Left,
    float Top
)

Parameters

• PresetTextEffect
  Type: Microsoft.Office.Core.MsoPresetTextEffect

  Required MsoPresetTextEffect. The preset text effect.

• Text
  Type: System.String

  Required String. The text in the WordArt.

• FontName
  Type: System.String

  Required String. The name of the font used in the WordArt.

• FontSize
  Type: System.Single

  Required Single. The size (in points) of the font used in the WordArt.

• FontBold
  Type: Microsoft.Office.Core.MsoTriState

  Required MsoTriState. The font used in the WordArt to bold.

• FontItalic
  Type: Microsoft.Office.Core.MsoTriState

  Required MsoTriState. The font used in the WordArt to italic.

• Left
  Type: System.Single

  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
  Type: System.Single

  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

Type: Microsoft.Office.Interop.Excel.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 you specify.

See Also

Reference

Shapes Interface

Shapes Members

Microsoft.Office.Interop.Excel Namespace