Use Input Boxes Sparingly

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.