Función InputBox
Mostra un campo nun diálogo para que o usuario introduza texto. A entrada atribúese a unha variábel.
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 ("").
Sintaxe:
InputBox (Mensaxe As String[, Título As String[, Predefinido As String[, pos_x As Integer, pos_y As Integer]]]])
Valor de retorno:
Cadea
Parámetro:
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.
Exemplo:
Sub ExampleInputBox
Dim sText As String
sTexto = InputBox ("Introduza unha frase: ","Prezado usuario")
MsgBox ( sTexto , 64, "Confirmación de frase")
End Sub