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 ("").
InputBox (Prompt As String[, Title As String[, Default As String[, xpostwips As Integer, ypostwips As Integer]]]) As String
prompt: 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.
xpostwips: Integer expression that specifies the horizontal position of the dialog. The position is an absolute coordinate and does not refer to the window of LibreOffice.
ypostwips: Integer expression that specifies the vertical position of the dialog. The position is an absolute coordinate and does not refer to the window of LibreOffice.
If xpostwips and ypostwips are omitted, the dialog is centered 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