TextFrame.VerticalOverflow (Excel)

Returns or sets the vertical overflow setting for the specified object. Possible return values are xlOartVerticalOverflowClip - Hide text that does not fit vertically within the text frame, xlOartVerticalOverflowEllipsis - Hide text that does not fit vertically within the text frame, and add an ellipsis (...) at the end of the visible text, xlOartVerticalOverflowOverflow - Allow text to overflow the text frame vertically (can be from the top, bottom, or both depending on the text alignment).

This property only has an effect when the AutoSize property is False.

Dim tfe As TextFrame: Set tfe = 
tfe.VerticalOverflow = xlOartVerticalOverflowClip