TextFrame2.HasText Property (Excel)
Returns whether the specified text frame has text. Read-only MsoTriState.
Version Information
Version Added: Excel 2007
Syntax
expression .HasText
expression A variable that represents a TextFrame2 object.
Example
This example formats the text in the text frame, if the text frame contains text.
With ActiveSheet.Shapes(1).TextFrame2
If .HasText Then
.TextRange2.Font.Name = "Arial"