TextFrame2.HasText Property

  • Article
Excel Developer Reference

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.

Visual Basic for Applications 
  With ActiveSheet.Shapes(1).TextFrame2
	If .HasText Then
		.TextRange2.Font.Name = "Arial"

See Also