I want to substitute Msgbox for a UserForm textbox

My actual code is huge, but works. Here is a smaller (test) version.
The code outputs to a Msgbox, but it is untidy (can't format it). So I would like to output to a UserForm textbox1 (which I hope allows formatting).
I have 2 UserForms.
UserForm1 is purely for control, behind a command button is all the code. (see below)
UserForm2 is for displaying the output in its textbox1.

How do I substitute the Msgbox for a textbox1 and point it to the textbox1 area in UserForm2

Please Login or Register  to view this content.

Ahhh thanks for that. Yes it did output to the desired textbox. Unfortunately all the data was on just 1 line.
I'll have to dig around now to see how to format the output from the 2 arrays. There must be an alternative to vbNewLine when using a Textbox.
If you have a formatting solution (that will probably save me hours of digging) that would be great.

O.K. I've found Multiline True (in Properties) gives me the new lines. Now all I have to do is get the output into nice straight columns.

Question: Is it possible to make the Textbox dynamic, i.e. it grows according to the number of lines output to it???
At the mo, the fixed size of the Textbox doesn't display all the lines of output. There is no vertical scroll bar to view them. Arghhhh help please.

Unless you use a fixed pitch font like Courier you cannot "get the output into nice straight columns".

Thank you xlnitwit, it's all looking a lot better now. I'll play around with listbox in my spare time and see what it offers me.
Much appreciated your advice.