/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 vote165 views1 answer
Replace spaces with underscores vbnet
VBA
1 vote161 views1 answer
Vba compile error object required
VBA
0 vote173 views1 answer
Vba border weight
VBA
0 vote156 views1 answer
Vbnet make a string to unicode converter
VBA
20 votes372 views1 answer
Excel vba factorial
VBA
0 vote196 views2 answers
Checking and changing system volume vb.net
VBA
0 vote199 views1 answer
Vba dictionary length
VBA
0 vote174 views1 answer
Vba get workbook name
VBA
22 votes346 views1 answer
Excel vba check if directory exists
VBA
0 vote167 views1 answer
Afficher un message d'erreur vba
VBA