EditPassword
Inserts a text edit control into the spreadsheet. For security, the text string that is entered will always be displayed as asterisks. The EditPassword control works like other interactive text input boxes.
Note:
- To access the property sheet for an EditPassword control, once the function has been inserted into the spreadsheet, right-click the control and select Edit Function.
- The text string is case-sensitive.
- The number of asterisks displayed equals the value specified for the Max String Length parameter.
EditPassword Inputs
Syntax: EditPassword(Max String Length)
| Parameter | Description |
|---|---|
|
Specifies the maximum text string length (in characters) that the edit box control will accept (1 to 255; default = 8). |
EditPassword Outputs
|
Returns |
The text string entered into the control, displayed as asterisks. Note: Although only asterisks are displayed, any cell referencing the EditPassword function will receive and display the actual string.
|
|
Results |
An EditPassword control. |