Active XText box vbcr shows symbol instead of an actual carraige return
 

Range("A11:D11") 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

Active XText box vbcr shows symbol instead of an actual carraige return
 

Hi Howard,

Am Sat, 13 Jul 2013 10:46:14 -0700 (PDT) schrieb Howard:

In the text box it displays this on a single line:
one, two(Para Symbol)four, five

in the properties of the textbox you have to set MultiLine is True
If you haven't you only see the symbol


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Active XText box vbcr shows symbol instead of an actual carraige return
 

On Saturday, July 13, 2013 11:01:17 AM UTC-7, Claus Busch wrote:
Hi Howard,



Am Sat, 13 Jul 2013 10:46:14 -0700 (PDT) schrieb Howard:



In the text box it displays this on a single line:

one, two(Para Symbol)four, five



in the properties of the textbox you have to set MultiLine is True

If you haven't you only see the symbol





Regards

Claus B.

--

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2

Okay, thanks.
I'll give it a go.
Really new to Active X stuff and text box goodies.
I do know there are a ton of properties and such.

Regards,
Howard