View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default Loading a Text Box

Setting MultiLine property of textbox to TRUE and using vbCRLF worked for me.

"John Mansfield" wrote:

I have a userform that contains one text box. The userform is activated by a
command button on a worksheet. As a simple example, when I hit the button I
want the userform to appear with the names Bill and Kim in the textbox
stacked one over the other i.e.

Bill
Kim

I can't figure out how to ge the line break to work.

I've tried:

Private Sub UserForm_Initialize()
TextBox1.Value = "Frank" & vbLineBreak & "Kim"
End Sub

and

Private Sub UserForm_Initialize()
TextBox1.Value = "Frank" & vbCrLf & "Kim"
End Sub

In the examples above I know a listbox would work. However, in reality I
have a sample of HTML code that is generated via a macro. I want that code
to appear in the text box. How can I get the textbox to allow line breaks?
Thanks for your help.

John