Displays a prompt in a dialogue at which the user can input text. The input is assigned to a variable.
The InputBox statement is a convenient method of entering text through a dialogue. Confirm the input by clicking OK or pressing Return. The input is returned as the function return value. If you close the dialogue 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 dialogue. 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 dialogue. 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 dialogue 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