/VBA/Xlvba double quotes in string literal

Xlvba double quotes in string literal

'The double quotation mark (") is ASCII character 34, so the 
'following Excel formula works:

=CHAR(34) & "Excel rocks." & CHAR(34)
'This formula will display:  "Excel rocks."

'Using triple double quotes has the same result:
="""Excel rocks."""

Source: academy.excelhero.com

Similar codes

0 vote290 views2 answers
Get excel file from email attachment in vba
VBA
0 vote282 views1 answer
Replace spaces with underscores vbnet
VBA
0 vote270 views1 answer
Vba loop through table
VBA
0 vote295 views1 answer
Excel VBA web scraping
VBA
0 vote291 views1 answer
Check if cell is dbnullvb.net
VBA
0 vote291 views1 answer
Search for text in every worksheet excel visual basic
VBA
0 vote284 views1 answer
Change form background image vb
VBA
0 vote288 views1 answer
Do while not vb.net
VBA
0 vote268 views1 answer
Putting marquee in vb.net
VBA
0 vote294 views1 answer
Loop through all text boxes in a form vb
VBA