Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,934
Default 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   Report Post  
Posted to microsoft.public.excel.programming
Tom Tom is offline
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,934
Default 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
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
Challenge - Excel Line Feed Character CHR(10) - How to Delete and keep the text formatting without going ro single line in a cell ? No Name Excel Worksheet Functions 7 October 7th 09 11:10 AM
display text when mouse passes over a line Farooq Sheri Excel Programming 1 March 15th 09 11:24 AM
Moving text from a line to a new line based on a condition Melanie Excel Programming 6 August 12th 08 08:43 PM
Getting line on line chart to display after creation from Pivot Table dcsi_jim Charts and Charting in Excel 8 February 6th 07 08:54 PM
A 2 line text showing up in the Cell in Excel prints in 1 line Danny Excel Discussion (Misc queries) 6 July 12th 05 08:47 PM


All times are GMT +1. The time now is 04:31 PM.

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

About Us

"It's about Microsoft Excel"