Below is the VBA code to put double quotes (quotation marks) for a string in excel. We can use CHR() function to print special characters like double quotes in excel VBA.
Chr(34) & stringToPrint & Chr(34)
Example:
Below is the VBA macro to print a string in double quotes (quotation marks (” “))
Sub printStringInDoubleQuotes() Dim strinToPrint stringToPrint = "string in double quotes" MsgBox (Chr(34) & stringToPrint & Chr(34)) ' Printing the string in double quotes End Sub
Output: