VBA quotes in string

Normally, VBA treats text between double quotes as a string and when you output the string there are no double quotes between the string. To display a string with quotes, you need to use Chr(char_code) function. This function converts a character code (integer) to its equivalent character. The character code for a double-quote is 34.

Example:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
     Dim str As String
     str = Chr(34) & "text inside quotes" & Chr(34)
     MsgBox str
End Sub

Posted by: Lavy | post date: 02-23-2013 | Subject: VBA for MS Excel




This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages:
C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.