Macro Sheets Only
Equivalent to choosing the Object command from the Format menu, and then choosing the Alignment tab, when a text box or button is selected, or when a chart is made active. Formats the selected worksheet text box or button or any text item on a chart.
Syntax
FORMAT.TEXT(x_align, y_align, orient_num, auto_text, auto_size, show_key, show_value, add_indent)
FORMAT.TEXT?(x_align, y_align, orient_num, auto_text, auto_size, show_key, show_value, add_indent)
Arguments correspond to check boxes or options in the various tabs on Format Object dialog box. Arguments that correspond to check boxes are logical values. If an argument is TRUE, Microsoft Excel selects the check box; if FALSE, Microsoft Excel clears the check box; if omitted, the current setting is used.
X_align is a number from 1 to 4 specifying the horizontal alignment of the text.
X_align Horizontal alignment
1 Left
2 Center
3 Right
4 Justify
Y_align is a number from 1 to 4 specifying the vertical alignment of the text.
Y_align Vertical alignment
1 Top
2 Center
3 Bottom
4 Justify
Orient_num is a number from 0 to 3 specifying the orientation of the text.
Orient_num Text orientation
0 Horizontal
1 Vertical
2 Upward
3 Downward
Auto_text corresponds to the Automatic Text check box. If the selected text was created with the Data Labels command from the Insert menu and later edited, this option restores the original text. Auto_text is ignored for text boxes on worksheets and macro sheets.
Auto_size corresponds to the Automatic Size check box. If you have changed the size of the border around the selected text, this option restores the border to automatic size. Automatic size makes the border fit exactly around the text no matter how you change the text.
Show_key corresponds to the Show Legend Key Next to Label check box in the Data Labels dialog box. This argument applies only if the selected text is an attached data label on a chart.
Show_value corresponds to the Show Value option button in the Format Data Labels dialog box. This argument applies only if the selected text is an attached data label on a chart.
The following list summarizes which arguments apply to each type of text item.
Add_indent This argument is for only Far East versions of Microsoft Excel.
Text item Arguments that apply
Worksheet text box or button X_align, y_align, orient_num, auto_size
Attached data label All arguments
Unattached text label X_align, y_align, orient_num, auto_size
Tickmark label Orient_num
Related Functions
CREATE.OBJECT Creates an object
FONT.PROPERTIES Applies a font to the selection
FORMULA Enters values into a cell or range or onto a chart
List of Command-Equivalent Functions