In Excel you can create input boxes using the input box function. As with message boxes, novice designers can get tempted to use pop up input boxes whenever possible. Don't. |
Having pop up input boxes can create navigation problems for inexperienced users of a spreadsheet-based DSS. Input of values may be slow and changing input may be tedious.
Pop up input boxes work best for entering something like a password, a file name or as a way to prompt a user for a specific input value.
To create an input box, enter the Visual Basic command variable=InputBox(Prompt,Title). variable is the name of the variable which will store the value, Prompt is the message text of the input box, and Title is the title of the input box.