I am trying to create a textbox which I can append data to. So each time a
sub is run, I want to pass a new string variable to the Value property of the
text box. Like the following:

Textbox1.Value - StringVar1

How do I append the additional text on each run? Think of this as a textbox
to view an ever increasing log file.

Thanks

EM

With TextBox1
..Text = .Text & StringVar1
End With

Regards,
Peter T

"Excel Monkey" wrote in message
...
I am trying to create a textbox which I can append data to. So each time a
sub is run, I want to pass a new string variable to the Value property of
the
text box. Like the following:

Textbox1.Value - StringVar1

How do I append the additional text on each run? Think of this as a
textbox
to view an ever increasing log file.

Thanks

EM