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.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim str As String
str = Chr(34) & "text inside quotes" & Chr(34)
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: