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

  • Thread starter Thread starter Howard
  • Start date Start date
H

Howard

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
 
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
Click to expand...

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.
 
Hi Howard,



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







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
Click to expand...

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
 
Back
Top