View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Append Text in Textbox

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