Sets the properties of an edit box on a dialog sheet.
Syntax
EDITBOX.PROPERTIES(validation_num, multiline_logical, vscroll_logical, password_logical)
EDITBOX.PROPERTIES?(validation_num, multiline_logical, vscroll_logical, password_logical)
Validation_num is the validation applied to the edit box when the dialog is dismissed. If the edit box contains a value other than the type specified (or validation), an error is returned.
| Validation_num | Type |
| 1 | Text |
| 2 | Integer |
| 3 | Number (allows floating point) |
| 4 | Reference |
| 5 | Formula |
Multiline_logical is a logical value specifying whether word wrapping is allowed in the edit box control. If TRUE, word wrapping is allowed. If FALSE, word wrapping is not allowed
Vscroll_logical is a logical value specifying whether edit box displays a vertical scrollbar. If TRUE, a scrollbar is displayed. If FALSE, a scrollbar is not displayed.
Password_logical is a logical value specifying whether edit box displays characters as the user types. If TRUE, asterisks (*) are displayed as the user types. If FALSE, no asterisks are displayed.
Related Functions
CHECKBOX.PROPERTIES Sets various properties of check box and option box controls
PUSHBUTTON.PROPERTIES Sets the properties of the push button control
Return to index