TextFrame2.DeleteText method (Excel)
Deletes the text from a text frame and all the associated text properties.
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 ()
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.