how to use (double) quotation mark as string in codes?

[ViestaWu]

Dear everyone,

double quotation mark (") is a reserved word in VB, but I need show it via
msgbox. How Can I do it?

Tks & BR
Viesta
Shanghai, China

 

[Dave Patrick]

MsgBox """Quoted response"""

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
| Dear everyone,
|
| double quotation mark (") is a reserved word in VB, but I need show it via
| msgbox. How Can I do it?
|
| Tks & BR
| Viesta
| Shanghai, China
|
|

 

[ViestaWu]

Hello Dave,

It works well. But I couldn't understand its syntax. could you explain to me?

BR
Viesta

 

[Bob Phillips]

You have to tell VBA that the quotes are part of the string, not a string
delimiter, so you pass it once to start the string, and then another two to
say this is to be included. At the end, it works the other way, two to say
this is a quotes to include, one to close the string.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

Hello Dave,

It works well. But I couldn't understand its syntax. could you explain to me?

BR
Viesta

MsgBox """Quoted response"""

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
| Dear everyone,
|
| double quotation mark (") is a reserved word in VB, but I need show it via
| msgbox. How Can I do it?
|
| Tks & BR
| Viesta
| Shanghai, China
|
|