Use Quotes in Strings in VBA

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.

How to properly use Excel String Co...
How to properly use Excel String Compare function?

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

Output:

Adding Double Quotes in String Using Extra Quotes

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

Output:

Adding Double Quotes in String Using Character Quote

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.

Related Article - VBA String

  • Compare Strings in VBA
  • Concatenate String in VBA
  • Convert String to Number in VBA