Prompt the user for input and store the result in a variable.
Syntax
ResultVariable = InputBox (prompt [, title ] [, default ]
[, xpos ] [, ypos ] [, helpfile ] [, context ] )
Key
prompt The message to display. up to ~1024 characters.
You can separate the lines using a carriage return character Chr(13),
a linefeed character Chr(10), or both (Chr(13) & Chr(10)) between each line.
title String to display in the title bar
default The default response if no other input is provided.
If you omit default, the text box is displayed empty.
xpos Optional 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 omitted, the dialog box is horizontally centered.
ypos Optional numeric expression that specifies, in twips,
the vertical distance of the upper edge of the dialog
box from the top of the screen.
If omitted, the dialog box is vertically positioned
approximately one-third of the way down the screen.
helpfile Optional string expression that identifies the Help file.
If helpfile is provided, context must also be provided.
context Optional numeric expression that is the Help context number
assigned to the appropriate Help topic by the Help author.
If context is provided, helpfile must also be provided.
If you specify the helpfile and context arguments, a Help button will be automatically added to the dialog box.
Examples
MyResult = InputBox (Prompt:="Enter data", _
HelpFile:="C:\Help\sample.chm", _
Context:="2001") MyResult2 = InputBox ("Enter the order date", "Demo input box")
“People who know little are usually great talkers, while men who know much say little” ~ Jean Jacques Rousseau
Related:
MsgBox - Display a message in a dialogue box.