Excel: INPUT() Requires Two Arguments

ID: Q89907

The information in this article applies to:

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

SYMPTOMS

The "Microsoft Excel Function Reference," 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 "Microsoft Excel Function Reference" states that if TYPE_NUM if omitted, it is assumed to be a value of 2. In fact, this argument cannot be omitted.

REFERENCES

"Microsoft Excel Function Reference," version 4.0, page 241

Additional query words: halt macro error

Keywords :
Version :
Platform :
Issue type :