Excel: INPUT() Requires Two Arguments

• 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        : 

Last Reviewed: March 29, 1999