Microsoft KB Archive/25138

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 13:51, 21 July 2020 by X010 (talk | contribs) (Text replacement - """ to """)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Excel: Placing Quotation Marks within a Text String in a Macro

Last reviewed: October 31, 1994
Article ID: Q25138


To create a text string (in a macro) that includes a word surrounded by quotation marks when it is in an alert or input box, use two double-quotation marks in a row within the text string.

For example, the word "red" will appear in the input box with quotation marks around it if you enter the following:

   =INPUT("Enter your favorite color (""red""):",2)

KBCategory: kbother


Additional reference words: 1.00 1.03 1.04 1.06 1.50 2.20 3.00

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