LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Looking for code to separate one line of text into multiple lines in Excel [email protected] Excel Worksheet Functions 1 February 13th 07 12:59 AM
How can I get excel to show ALL lines of wrapped text? bmg Excel Worksheet Functions 0 December 27th 05 05:39 PM
How do I merge 3 lines of text to show in one row? pita29 Excel Discussion (Misc queries) 3 August 7th 05 02:36 AM
formatting text in TextBox in UserForm Kevin Excel Programming 2 November 7th 03 01:34 PM
Retaining text formatting in TextBox Tom Ogilvy Excel Programming 0 September 9th 03 08:05 PM


All times are GMT +1. The time now is 11:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"