Microsoft KB Archive/89907

{|
 * width="100%"|

Excel: INPUT Requires Two Arguments

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, version 4.0
 * Microsoft Excel for the Macintosh, version 4.0

-

SYMPTOMS
The &quot;Microsoft Excel Function Reference,&quot; version 4.0, incorrectly states that the second argument, TYPE_NUM, for the INPUT function may be omitted. However, if you omit this argument, you receive the following error message when you enter the INPUT function:

Too Few Arguments

STATUS
This problem has been corrected in Microsoft Excel version 5.0. In Microsoft Excel version 5.0, you can use the INPUT function in a Microsoft Excel version 4.0 macro sheet with only the message_text argument.

MORE INFORMATION
The INPUT function displays a dialog for user input. The TYPE_NUM argument specifies the type of data to be entered in the input dialog. Page 241 of the &quot;Microsoft Excel Function Reference&quot; states that if TYPE_NUM if omitted, it is assumed to be a value of 2. In fact, this argument cannot be omitted.