putting reference in quotations

[Noz2k]

Quick question I think.

but I have some code like

 N = textbox1 & textbox2
X = N & " Or " textbox3

so say textbox1 = A, textbox2 = B and textbox3 = C

X would equal AB Or C

but I need it to be X = "AB" Or "C"

if I try to put quotations marks in I get

X = "N" Or "textbox3"

ANy idea how I do this?

 

[bertie]

When inserting double quotations I use the ASCII character chr(34).

Test this code, apologies for not declaring the variables:

[COLOR=darkblue]Sub[/COLOR] test()
   
   textbox1 = "A"
   textbox2 = "B"
   textbox3 = "C"
   
   n = Chr(34) & textbox1 & textbox2 & Chr(34)
   Debug.Print n
   
   x = n & " or " & Chr(34) & textbox3 & Chr(34)
   Debug.Print x
   
[COLOR=darkblue]End[/COLOR] [COLOR=darkblue]Sub[/COLOR]