TextFrame2.DeleteText Method

  • Article
Excel Developer Reference

Deletes the text from a text frame and all the associated text properties.

Version Information
 Version Added:  Excel 2007

Syntax

expression.DeleteText

expression   A variable that represents a TextFrame2 object.

Remarks

The associated text properties include Font attributes such as bold, underline, and so on.

Example

This example deletes the text in the text frame, if the text frame contains text.

Visual Basic for Applications 
  With ActiveSheet.Shapes(1).TextFrame2
	If .HasText Then
		.DeleteText ()

See Also