Text Frame Properties

Name

Returns

Description

AutoMargins

Boolean

Set/Get whether Excel will calculate the margins of the text frame automatically. Set this property to False to use the MarginLeft, MarginRight, MarginTop, and Margin-Bottom properties

AutoSize

Boolean

Set/Get whether the size of the text frame changes to match the text inside

Horizontal Alignment

XlHAlign

Set/Get how the text frame is horizontally aligned. Use the XLHAlign constants

MarginBottom

Single

Set/Get the bottom spacing in a text frame

MarginLeft

Single

Set/Get the left spacing in a text frame

MarginRight

Single

Set/Get the right spacing in a text frame

MarginTop

Single

Set/Get the top spacing in a text frame

Orientation

MsoText Orientation

Set/Get the orientation of the text in the text frame

Name Returns Description

ReadingOrder Long Set/Get whether the text in the frame is read from right-to-

left (xlRTL), is read from left-to-right (xlLTR), or is context sensitive (xlContext)

Vertical XlVAlign Set/Get how the text frame is vertically aligned. Use the

Alignment XlVAlign constants

0 0

Post a comment