Displays a prompt in a dialog box, waits for the user to input text or click a button, and returns the contents of the text box.
InputBox(prompt[, title][, default][, xpos][, ypos][, helpfile, context])
The InputBox syntax has these arguments:
| Part | Description |
|---|---|
| prompt | String expression displayed as the message in the dialog box. The maximum length of prompt is approximately 1024 characters, depending on the width of the characters used. If prompt consists of more than one line, you can separate the lines using a carriage return character (Chr(13)), a linefeed character (Chr(10)), or carriage return–linefeed character combination (Chr(13) & Chr(10)) between each line. |
| title | String expression displayed in the title bar of the dialog box. If you omit title, the application name is placed in the title bar. |
| default | String expression displayed in the text box as the default response if no other input is provided. If you omit default, the text box is displayed empty. |
| xpos | Numeric expression that specifies, in twips, the horizontal distance of the left edge of the dialog box from the left edge of the screen. If xpos is omitted, the dialog box is horizontally centered. |
| ypos | Numeric expression that specifies, in twips, the vertical distance of the upper edge of the dialog box from the top of the screen. If ypos is omitted, the dialog box is vertically positioned approximately one-third of the way down the screen. |
| helpfile | Not Supported |
| context | Not Supported. |
If the user clicks OK or presses ENTER, the InputBoxreturns whatever is in the text box. If the user clicks Cancel, thereturns a zero-length string ("").