Multiple lines in a text box

[Satal Keto]

What i want to do is get more than one line of text in a text box.

I know that the following code will change the text of a text box to Hello

Private Sub CommandButton1_Click()
TextBox1.Text = "Hello"
End Sub

But what i would like to do is get it to change the text of the text box to...

Hello
World

I know that i can do a more than one line in a MsgBox by using the code

Private Sub CommandButton1_Click()
MsgBox "Hello" & vbCrLf & "World"
End Sub

But you can't use & vbCrLf & like that in a text box.

Does anyone have any ideas of how i would be able to achieve this?

 

[staticbob]

Hi Satal, welcome to the board !!!

This is from the macro recorder !

 ActiveSheet.Shapes("Text Box 1").Select
 Selection.Characters.Text = "Hello" & Chr(10) & "World" & Chr(10) & ""

Bob

 

[zoso]

I'm not 100% on this, but if you right click the text box and select Properties, there will be a field along the lines of 'allow multiple line' - that needs to be changed to Yes.

HTH!

 

[staticbob]

Ooops, I stooopidly assumed you were working with a standard textbox.

Zoso is spot on, there is a multiline property, when set to true your messagebox code will work fine.

Bob

 

[Satal Keto]

Wow that has to be the quickest i have got an answer on a message board, let alone one which actually helped me :D
I changed the code slightly to

Private Sub CommandButton1_Click()
TextBox1.Text = "Hello" & Chr(10) & "World" & Chr(10) & ""
End Sub

I kept getting the paragraph symbol, which i didn't realise was because i didn't have the multiple line set to true.

So thank you staticbob and thank you ZOSO.

 

[staticbob]

Glad it helped . . . . . and I'm just trying to hit my 1000th post. LOL

 

[Satal Keto]

Now maybe if i replied to that asking for a reply for something maybe you could send me another reply which would take you up another post?

Or would that be against the rules?

 

[staticbob]

I'm not sure thats allowed Satal, nice thought tho.

 

[Satal Keto]

Ok well i thought it might have been worth a try, good thing i checked before starting making random convosation to try and get your posts up.
But anyway thanks for the help with the new lines ive spent ages trying to figure that out.

 

[staticbob]

Not a problem mate, glad I could help... LOL

Bob

(I'm gonna save my 1000th for a genuine post !)