Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 | | |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 | | |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula For Finding a Quotation Mark In a String | Excel Worksheet Functions | |||
Excel CSV file: How to preserve double quotation mark on Unix ftp? | Excel Discussion (Misc queries) | |||
Single or Double Quotation Mark and it comes up twice | Setting up and Configuration of Excel | |||
How to include a double quotation character in a string? | Excel Programming | |||
chr() for quotation mark | Excel Programming |