We will introduce how to use double quotes in strings in VBA with some examples.
Use Quotes in Strings in VBA
While working with VBA, we have always wondered what to do if we want to include double quotes in a string and use them in our functions without any problems. There are multiple ways to use the double quotes inside strings without getting into any errors and problems.
We will discuss these methods one by one with examples.
Use Extra Double Quotes to Use Quotes in Strings in VBA
The first example is by using extra double quotes. If we use two extra double quotes, it will include only one double quote inside the string.
Let’s go through an example and use this method as shown below.
# VBA Sub addDoubleQuotes() Value = "This is a string including ""doublequotes""" Selection.Value = Value End Sub
As we can see from the example, we can easily add one double quote inside a string by adding two double quotes.
Use the Character Code for Double Quotes to Use Quotes in Strings in VBA
Let’s now go through another example in which we will use a character code to add double quotes inside our string, as shown below.
# VBA Sub addDoubleQuotes() Value = "This is a string including " & Chr(34) & " doublequotes " & Chr(34) Selection.Value = Value End Sub
As we can see from the example, by using the character code for double quotes, which is
Chr(34), we can easily add double quotes inside strings in VBA.