TextEffectFormat.FontName property (Excel)

Returns or sets the name of the font in the specified WordArt. Read/write String.

Syntax

expression.FontName

expression A variable that represents a TextEffectFormat object.

Example

This example sets the font name to Courier New for shape three on myDocument if the shape is WordArt.

Set myDocument = Worksheets(1) 
With myDocument.Shapes(3) 
 If .Type = msoTextEffect Then 
 .TextEffect.FontName = "Courier New" 
 End If 
End With

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.