Excel: {ENTER} with ON.KEY Differs Between VersionsID: Q79086
|
When you use the ON.KEY function with "{ENTER}" or "~" as the key text, the ENTER key needs to be pressed twice in Microsoft Excel version 2.1 to run the macro specified. The ENTER key only needs to be pressed once in Microsoft Excel versions 3.0, 4.0, 4.0a, or 5.0 to cause the macro to run.
The following macro, which displays an alert box when the ENTER key is
pressed, illustrates the differences in the two versions.
A1: =ON.KEY("~","R4C1")
A2: =RETURN()
A3:
A4: =ALERT("testing")
A5: =RETURN()
"Microsoft Functions Reference Manual," version 3.0, page 165
"Microsoft Functions and Macros," version 2.1, page 321
Additional query words:
Keywords :
Version :
Platform :
Issue type :
Last Reviewed: March 23, 1999