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)
"gtslabs" wrote in message
ups.com...
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 & """"