InputBox Function
Displays a prompt in a dialog box, waits for the user to input text or click
a button, and returns the contents of the text box.
InputBox(prompt[, title][, default][,
xpos][, ypos][, helpfile, context])
Arguments
prompt
String expression
displayed as the message in the dialog box. The maximum length of
prompt is approximately 1024 characters, depending on the width of the
characters used. If prompt consists of more than one line, you can
separate the lines using a carriage return character (Chr(13)), a
linefeed character (Chr(10)), or carriage return–linefeed
character combination (Chr(13) & Chr(10)) between each
line.
title
String expression displayed in the title bar of the dialog box.
If you omit title, the application name is placed in the title bar.
default
String expression displayed in the text box as the default
response if no other input is provided. If you omit default, the text box
is displayed empty.
xpos
Numeric expression
that specifies, in twips, the horizontal distance of the left
edge of the dialog box from the left edge of the screen. If xpos is
omitted, the dialog box is horizontally centered.
ypos
Numeric expression that specifies, in twips, the vertical
distance of the upper edge of the dialog box from the top of the screen. If
ypos is omitted, the dialog box is vertically positioned approximately
one-third of the way down the screen.
helpfile
String expression that identifies the Help file to use to
provide context-sensitive Help for the dialog box. If helpfile is
provided, context must also be provided.
context
Numeric expression that identifies the Help context number
assigned by the Help author to the appropriate Help topic. If context is
provided, helpfile must also be provided.
Remarks
When both helpfile and context are supplied, a Help button is
automatically added to the dialog box.
If the user clicks OK or presses ENTER, the InputBox
function returns whatever is in the text box. If the user clicks Cancel,
the function returns a zero-length string ("").
The following example uses the InputBox function to display an input
box and assign the string to the variable Input: Dim Input
Input = InputBox("Enter your name")
MsgBox ("You entered: " & Input)
|