Macro Sheets Only
Replaces characters in a text box or button with the text you specify.
Syntax
TEXT.BOX(add_text, object_id_text, start_num, num_chars)
Add_text is the text you want to add to the text box or button.
Object_id_text is the name of the text box or button to which you want to add text (for example, "Text 1" or "Button 2"). If object_id_text is omitted, it is assumed to be the selected item.
Start_num is a number specifying the position of the first character you want to replace (or the position at which you want to insert characters if you do not want to replace any). If start_num is omitted, it is assumed to be 1.
Num_chars is the number of characters you want to replace. If num_chars is 0, then no characters are replaced, and add_text is inserted starting at the position start_num. If num_chars is omitted, all the characters are replaced.
Examples
The following macro formula replaces the first five characters in a text box named "Text 5" with the text "Net Income":
TEXT.BOX("Net Income", "Text 5", 1, 5)
The following macro formula inserts the words "Account Summary for 1991" at the beginning of a text box named "Text 6":
TEXT.BOX("Account Summary for 1991", "Text 6", 1, 0)
Related Functions
CREATE.OBJECT Creates an object
FONT.PROPERTIES Applies a font to the selection
GET.OBJECT Returns information about an object
List of Command-Equivalent Functions