Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Looking for code to separate one line of text into multiple lines in Excel | Excel Worksheet Functions | |||
How can I get excel to show ALL lines of wrapped text? | Excel Worksheet Functions | |||
How do I merge 3 lines of text to show in one row? | Excel Discussion (Misc queries) | |||
formatting text in TextBox in UserForm | Excel Programming | |||
Retaining text formatting in TextBox | Excel Programming |