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
> |
> |
>
>
>

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" <viesta.wu@konecranes.com> wrote in message
news:3CD513E4-0AAE-4AA4-9F99-D3A265F2ADAA@microsoft.com...
> 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
> > |
> > |
> >
> >
> >