Display a 5 column range in a textbox or scrollable label

Hi to all Gurus,

I have a 5 column range that i want to display in a userform.
As the range will grow in length I will need a scrollable textbox or label (don't think this can have scrollbars though??)
I can get the range into a textbox, using a user function found on another website (sorry), but I need the data to wrap to the 5 columns, that is a new line after 5 values. I can't get my head around this part.

Thanks in advance for the help.
Kingali

Hi everyone,
Solved it through trial and error and help. Code posted to help others.

Public Function Join2(seperator As String, rng As Variant) As String
'http://stackoverflow.com/questions/13121413/how-to-display-selected-range-of-cells-in-textbox1-using-vba-code

Dim joinedString As String
Dim cell As Variant
Dim v As Integer

    v = 0
    For Each cell In rng
        v = v + 1
            joinedString = joinedString & cell & seperator
        If v = 5 Then
            joinedString = joinedString & vbCrLf
            v = 0
        End If
    Next cell
    joinedString = Left(joinedString, Len(joinedString) - Len(seperator))
    Join2 = joinedString
End Function

Kingali

Hi Norie,
Thanks for your reply.
I have never used a listbox so didn't know its capabilities.
Your solution automatically puts the values into their respective columns saving me extra coding.
Ab Fab. That teaches me to look elsewhere. Stick with the forum you know and like. - Excelforum.com

Thanks again
Kingali