H
Howard
Range("A1111") values = one two three four
Option Explicit
Sub TheT_Box()
Dim MyStringVariable As String
MyStringVariable = Range("A11").Value & ", " & Range("B11").Value _
& vbCr & Range("C11").Value & ", " & Range("D11").Value
TextBox1.Text = MyStringVariable
End Sub
In the text box it displays this on a single line:
one, two(Para Symbol)four, five
Where (Para Symbol) is the two-staff backward P
Copy that text string here it displays as:
one, two
three, four
I want the later IN the text box.
Is that in keeping with proper use of a Active X Text Box?
Regards,
Howard
Option Explicit
Sub TheT_Box()
Dim MyStringVariable As String
MyStringVariable = Range("A11").Value & ", " & Range("B11").Value _
& vbCr & Range("C11").Value & ", " & Range("D11").Value
TextBox1.Text = MyStringVariable
End Sub
In the text box it displays this on a single line:
one, two(Para Symbol)four, five
Where (Para Symbol) is the two-staff backward P
Copy that text string here it displays as:
one, two
three, four
I want the later IN the text box.
Is that in keeping with proper use of a Active X Text Box?
Regards,
Howard