Microsoft KB Archive/51385: Difference between revisions
(importing KB archive) |
m (Text replacement - "&" to "&") |
||
Line 15: | Line 15: | ||
Note: You must replace the formula in cell A4 with: | Note: You must replace the formula in cell A4 with: | ||
A4: =FORMULA(“=”“first line”& | A4: =FORMULA(“=”“first line”&CHAR(13)&“second line”"") | ||
for this to work with Excel version 3.0. Note the use of the double quotation marks (""), the ampersands (& | for this to work with Excel version 3.0. Note the use of the double quotation marks (""), the ampersands (&), and the CHAR(13) function. | ||
Additional reference words: 2.0 2.00 2.10 2.1 2.2 2.20 2.21 3.0 3.00 | Additional reference words: 2.0 2.00 2.10 2.1 2.2 2.20 2.21 3.0 3.00 | ||
Copyright Microsoft Corporation 1993. | Copyright Microsoft Corporation 1993. |
Revision as of 14:20, 21 July 2020
Entering a Two-Line Chart Title from a Macro PSS ID Number: Q51385 Article last modified on 02-26-1993 PSS database name: W_eXceL
2.00 2.01 2.10 3.00 | 2.20 2.21 3.00
WINDOWS | OS/2
Summary:
To enter a two-line chart title from a macro, use the following code as an example:
A1: Title A2: =ACTIVATE(“Chart1”) A3: =ATTACH.TEXT(1) A4: =FORMULA(“=”“first line|second line”"") A5: =RETURN()
The vertical bar is created by pressing ALT+Keypad 0013. This enters the ANSI character 13, which is equivalent to using the CTRL+ENTER key combination.
Note: You must replace the formula in cell A4 with:
A4: =FORMULA(“=”“first line”&CHAR(13)&“second line”"")
for this to work with Excel version 3.0. Note the use of the double quotation marks (""), the ampersands (&), and the CHAR(13) function.
Additional reference words: 2.0 2.00 2.10 2.1 2.2 2.20 2.21 3.0 3.00
Copyright Microsoft Corporation 1993.