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.