Quotes around text in Msgbox
Try this:
MsgBox "Question 2 is answered " & """Other, Please specify"""
& " but there is no text in the adjacent cell. Please enter the data there."
Does that help?
--------------------------
Regards,
Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
"davegb" wrote in message
...
I searched this forum but couldn't find the same situation. I want to
have quotes around some text in other text in a Msgbox. I want the
text in the Msgbox to read,
Question 2 is answered "Other, Please specify" but there is no text in
the adjacent cell. Please enter the data there.
.
I've tried a couple of combinations, the last being:
MsgBox "Question 2 is answered" & ""Other, Please specify"" & "but
there is no text in the adjacent cell. Please enter the data there."
How do I get the quotes in the message box text?
As always, thanks!
|