Microsoft KB Archive/66635

{| = Macro Error with CTRL+ENTER Key Combination =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q66635

SUMMARY
If you use the key sequence CTRL+ENTER, which is used in charting to enter text on more than one line, a problem may occur when editing that line in a macro. Specifically, if you edit a text entry that has more than one line, the next select statement that doesn't select a multiline text entry will cause a macro error.

The following is an example:

A  1       =SELECT(&quot;Title&quot;) 2      =SELECT(&quot;Text S2P3&quot;) 3      =RETURN If &quot;Title&quot; was a two-line text entry such as &quot;Microsoft Corporation&quot; and &quot;Text S2P3&quot; was a one-line text entry such as &quot;Point3&quot;, the macro above would produce an error when it gets to the second Select statement. Recording and running a macro like the one above will produce the same error. However, if &quot;Text S2P3&quot; was a two-line text entry, the macro would run without producing an error.

Microsoft Excel for Windows version 3.00 works as expected and will generate no error of this type.
 * }