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 & """"

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 & """"

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

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

--
Jay


"gtslabs" wrote:

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 & """"