{ENTER} Not Working as Documented in Excel Manual

Last reviewed: November 7, 1994
Article ID: Q70722

The information in this article applies to:

Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 5.0

SUMMARY

Page 166 of the "Microsoft Excel Function Reference" (version 3.0) states that the KEY_TEXT, {ENTER}, or ~ (tilde) can be used interchangeably in the ON.KEY function. This is true for versions of Microsoft Excel earlier than 3.0. However, in version 3.0 of Microsoft Excel, the KEY_TEXT, {ENTER}, specifies the numeric keypad ENTER key, and the KEY_TEXT, ~, specifies the ENTER key on the main keyboard

MORE INFORMATION

The ON.KEY function will run the specified macro when a particular key or key combination is pressed. The above mentioned change will allow you to independently specify the main keyboard and numeric keypad ENTER keys.

REFERENCES

"Online Help," version 5.0 "Function Reference," version 4.0, pages 302-304 "Function Reference," version 3.0, pages 165-166

KBCategory: kbdocerr
KBSubcategory:
Additional reference words: send 2.0 2.01 2.1 2.10 3.0 3.00 4.0 4.00

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 7, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.