TextFrame2.DeleteText Method (Excel)
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.
With ActiveSheet.Shapes(1).TextFrame2
If .HasText Then
.DeleteText ()