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

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
 
C

Claus Busch

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.
 
H

Howard

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top