InputBox Function

Displays a prompt in a dialog 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 dialog. Confirm the input by clicking OK or pressing Return. The input is returned as the function return value. If you close the dialog 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 dialog box.

Title: String expression displayed in the title bar of the dialog 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 centered 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

Please support us!