Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to display first line in a text box
I have a EULA displaying in a text box with scroll bars. However the
display shows the end of the text not the first line. Is there a way to display the top line or another approach? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to display first line in a text box
Set the SelStart property to 0.
-- Rick (MVP - Excel) "TJ" wrote in message ... I have a EULA displaying in a text box with scroll bars. However the display shows the end of the text not the first line. Is there a way to display the top line or another approach? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to display first line in a text box
Thanks, Rick
Is there a way to display Rich Text Format in a text box? or other approach? "Rick Rothstein" wrote in message ... Set the SelStart property to 0. -- Rick (MVP - Excel) "TJ" wrote in message ... I have a EULA displaying in a text box with scroll bars. However the display shows the end of the text not the first line. Is there a way to display the top line or another approach? Thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to display first line in a text box
Is there a way to display Rich Text Format in a text box? or other
approach? I'm not sure how to answer this question. When I check for "More Controls" on my UserForm's Toolbox or the ActiveX Control Toolbox toolbar on the Excel worksheet, there is a... Microsoft Rich Textbox Control 6.0 (SP6) control I can select, but I don't believe it is native to Windows.... I *think* it was made available when I installed my copy of the compiler version of VB6... the SP6 makes me think that as my copy of VB6 (the compiler version) is at Service Pack 6. If you have this control available to you as well, and if you don't have the compiler version of VB installed, then that *might* mean you have installed an application that was made with the compiled version of VB and that installation could have put the Rich TextBox on your system. The reason I am going through all of this is to warn you that if you have the Rich TextBox available, it might not be because Windows provided it; and if Windows didn't provide it, then you cannot expect all systems that run use your workbook to be able to have the control available to them as well. -- Rick (MVP - Excel) "Tom" wrote in message ... Thanks, Rick Is there a way to display Rich Text Format in a text box? or other approach? "Rick Rothstein" wrote in message ... Set the SelStart property to 0. -- Rick (MVP - Excel) "TJ" wrote in message ... I have a EULA displaying in a text box with scroll bars. However the display shows the end of the text not the first line. Is there a way to display the top line or another approach? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Challenge - Excel Line Feed Character CHR(10) - How to Delete and keep the text formatting without going ro single line in a cell ? | Excel Worksheet Functions | |||
display text when mouse passes over a line | Excel Programming | |||
Moving text from a line to a new line based on a condition | Excel Programming | |||
Getting line on line chart to display after creation from Pivot Table | Charts and Charting in Excel | |||
A 2 line text showing up in the Cell in Excel prints in 1 line | Excel Discussion (Misc queries) |