Displays a prompt in a dialogue box at which the user can enter text. The input is assigned to a variable.
The InputBox statement is a convenient method of entering text through a dialogue box. Confirm the input by clicking OK or pressing Return. The input is returned as the function return value. If you close the dialogue box with Cancel, InputBox returns a zero-length string ("").
InputBox (Msg As String[, Title As String[, Default As String[, x_pos As Integer, y_pos As Integer]]]])
Msg: String expression displayed as the message in the dialogue box.
Title: String expression displayed in the title bar of the dialogue box.
Default: String expression displayed in the text box as default if no other input is given.
x_pos: Integer expression that specifies the horizontal position of the dialog. The position is an absolute coordinate and does not refer to the window of the office application.
y_pos: Integer expression that specifies the vertical position of the dialog. The position is an absolute coordinate and does not refer to the window of the office application.
If x_pos and y_pos are omitted, the dialog is centred on the screen. The position is specified in twips.
Sub ExampleInputBox Dim sText As String sText = InputBox("Please enter a phrase:", "Dear User") MsgBox(sText, 64, "Confirmation of phrase") End Sub