Quotes around text in Msgbox

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

davegb - 03 Mar 2008 17:22 GMT

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!

Reply to this Message

Ron Coderre - 03 Mar 2008 17:26 GMT

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)

>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
[quoted text clipped - 10 lines]
>
> As always, thanks!

Reply to this Message

Ron Coderre - 03 Mar 2008 17:33 GMT

or...this:

MsgBox "Question 2 is answered ""Other, Please specify"" but there is
no text in the adjacent cell. Please enter the data there."

--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

> Try this:
>
[quoted text clipped - 25 lines]
>>
>> As always, thanks!

Reply to this Message

davegb - 03 Mar 2008 17:40 GMT

On Mar 3, 10:26 am, "Ron Coderre" <ronREMOVETHIScode...@bigfoot.com>
wrote:

> Try this:
>
[quoted text clipped - 26 lines]
>
> - Show quoted text -

Hey, what took you guys so long? I posted almost 5 min ago. :)
Thanks for both replies. Problem solved, and in 5 min!

Reply to this Message

glenndwhite2@gmail.com - 03 Mar 2008 17:31 GMT

> 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
[quoted text clipped - 10 lines]
>
> 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)

Reply to this Message

LeShark - 03 Mar 2008 17:34 GMT

Just use three " where you have two and it should work

MsgBox "Question 2 is answered" & """ Other, Please specify """ & "but etc etc

> 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
[quoted text clipped - 10 lines]
>
> As always, thanks!

Reply to this Message

Bill Martin - 03 Mar 2008 17:56 GMT

>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
[quoted text clipped - 10 lines]
>
>As always, thanks!

----------------------------------

The easy, "cheating" solution is to use single quotes in your message
rather than double. i.e. 'Other, Please specify.'

Bill

Reply to this Message