Microsoft KB Archive/25138

{| = Excel: Placing Quotation Marks within a Text String in a Macro =
 * width="100%"|

Last reviewed: October 31, 1994

Article ID: Q25138

SUMMARY
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)
 * }