I have a userform that I would like to display a string of text in. I have built the string using the code below:
Private Sub UserForm_Initialize()
Dim rngComments As Range
Dim strcombuild As String
Set rngComments = Range("Comments")
strcombuild = ""
.CommandButton1.Caption = "Close"
For Each rw In rngComments.Rows
i = 1
If rw.Columns(1).Value = TaskID Then
For Each cl In rw.Cells.Columns
If i = 1 Then
strcombuild = strcombuild & rw.Cells(1, i).Value
strcombuild = strcombuild & " - " & rw.Cells(1, i).Value
i = i + 1
strcombuild = strcombuild & "." & vbNewLine
Me.Textbox1 = strcombuild
When I set Textbox1=strcombuild, it just displays one continuous line of text with like a paragraph marker where the carriage / line return should be.
When I assign Label1=strcombuild it displays fine.
I would like to have the text displayed on multiple lines in Textbox1 - any help would be appreciated.