View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
L Mehl L Mehl is offline
external usenet poster
 
Posts: 73
Default Formatting text in a textbox to show separate lines

Hello --

I want to populate a textbox so user can copy any or all of its information
to another field.

Contents of the text box are built up by parsing a text string and repeating
in a loop:

strComment = strComment & _
vbCrLf & _
Trim(strTempText)

where strTempText is the parsed/loop value

The desired result looks like separate lines:

Start time: 1059167091
End time: 1059167104
Proto: TCP
Source IP: 216.218.241.95
Source name: abc.com
src port: 20
Dest IP: 102.999.50.12
Dest name: eleuthera
Dest port: 1060
Connection number: 1
Total packets: 641
Total payload: 931760

I am able to get this format when I display a message box containing the
final value of strComment.

However, when I put the final value of strComment in a textbox, it appears
as one long string.

Can someone help me build strComment so that it appears in a textbox looking
like separate lines?

Thanks for any help.

Larry Mehl



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.581 / Virus Database: 368 - Release Date: 2/9/2004