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.

Please Login or Register  to view this content.

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