InputBox Function

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 ("").

Syntax:

InputBox (Msg As String[, Title As String[, Default As String[, x_pos As Integer, y_pos As Integer]]]])

Return value:

String

Parameter:

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.

Example:

Sub ExampleInputBox

Dim sText As String

    sText = InputBox ("Please enter a phrase:","Dear User")

    MsgBox ( sText , 64, "Confirmation of phrase")

End Sub