Thread: Nested " " "
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Nested " " "

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