Nested " " "

[gtslabs]

I am trying to get a text string to look like this: "SCN 25" from the
inputbox
But I am having problems. the tripple quotes on the right side work
but it wont let me do it on the left side. What is the procedure
here?

Thanks

scnrate = InputBox("Scanning Rate (milliseconds) Range = 25 - 100",
"Set Scanning Rate", 25)
MsgBox """ & "SCN " & scnrate & """"

 

[Chip Pearson]

I find it much easier to use Chr(34) where I want a quote mark rather than
nesting up several levels of double and triple " characters.


MsgBox "SCN " & Chr(34) & scnrate & Chr(34)

displays

SCN "25"

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)

 

[Guest]

Try one more double quote on the very left of the string (there needs to be 4
double quotes):

MsgBox """" & "SCN " & scnrate & """"