Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to display some tab delimited data in a textbox.
The text box is not wide enough to see all the data. I have a vbCrLf at the end of each record. So my text box is being populated like this: For I = 1 to alot TB_output = TB_output & data1 & vbTab & data2 & ...... & vbCrLf Next alot I have scroll bars turned on and multiline = true However it wraps data to the next line in the textbox before the vbCrLf statement and at the vbCrLf. The scroll bar is NOT displayed If I turn multiline to False I get the scroll bars to appear but data is all on one line and the vbcrlf is displayed as a character. How do I see multiline data and horizontal scroll bars using vbCrLf I may have too many lines to put into a list box. Plus I want the option to copy and paste data easily in the future |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Remove small square caused by vbCrLf | Excel Programming | |||
Deleting a row in a message (opposite to VbCrLf) | Excel Programming | |||
VBCRLF not doing anything | Excel Programming | |||
Automatic linewrap with formulas displayed | Excel Worksheet Functions | |||
square boxes when using vbcrlf | Excel Programming |