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

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

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

MsgBox """Quoted response"""

--

Regards,

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

"ViestaWu" wrote:
| 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
|
|

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

Hello Dave,

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

BR
Viesta

"Dave Patrick" wrote:

MsgBox """Quoted response"""

--

Regards,

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

"ViestaWu" wrote:
| 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
|
|

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

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)

"ViestaWu" wrote in message
...
Hello Dave,

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

BR
Viesta

"Dave Patrick" wrote:

MsgBox """Quoted response"""

--

Regards,

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

"ViestaWu" wrote:
| 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
|
|