View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] glenndwhite2@gmail.com is offline
external usenet poster
 
Posts: 2
Default Quotes around text in Msgbox

On Mar 3, 12:22*pm, davegb wrote:
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!


You can directly enter the ascii code for ", which is 34
if you want the box to say: "hello"
then put the following: Msgbox Chr(34) & "hello" & Chr(34)