escape character

S

sam

Hi,
does anyone know what the escape character in vba is?

like i want to make " part of a string but it always
takes it as the end of the string.
thanx
 
C

Chip Pearson

Sam,

VBA doesn't have an escape character as such. Use two "
characters. E.g.,

Dim S As String
S = "This has a ""quoted"" word."


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Top