Excel: INPUT() Requires Two Arguments

 Last reviewed: November 29, 1994
Article ID: Q89907
The information in this article applies to:
  • Microsoft Excel for Windows, versions 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

KBCategory: kbdocerr
KBSubcategory:

Additional reference words: 4.0 4.00 halt macro error

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 29, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.