TextEffectFormat.FontSize Property (Excel)
Returns or sets the font size for the specified WordArt, in points. Read/write Single.
Syntax
expression .FontSize
expression A variable that represents a TextEffectFormat object.
Example
This example sets the font size to 16 points for the shape named "WordArt 4" in myDocument.
Set myDocument = Worksheets(1)
myDocument.Shapes("WordArt 4").TextEffect.FontSize = 16