Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 156
Default String in text box


I'm building up a rather complex string
and displaying it in a text box.

The text box is a fixed size, which is fine
as most outputs don't fill it. But when it
does, you see the last line and a cursor.

It'd be better is you could see the first line.

Is that possible?

Thanks - Kirk
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default String in text box

Kirk,
Check out the .SelStart, .SelText .SelLength properties of the TextBox.

NickHK

"kirkm" wrote in message
...

I'm building up a rather complex string
and displaying it in a text box.

The text box is a fixed size, which is fine
as most outputs don't fill it. But when it
does, you see the last line and a cursor.

It'd be better is you could see the first line.

Is that possible?

Thanks - Kirk



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 156
Default String in text box

On Tue, 6 Mar 2007 17:25:26 +0800, "NickHK"
wrote:

Kirk,
Check out the .SelStart, .SelText .SelLength properties of the TextBox.


Hi, I read the Help on those (which didn't make much sense to me).

Tried a few things but nothing worked as hoped - or gave errors.
Stuff about SetFocus and other complications.

Suppose I'll just have to leave the cursor at the end and scroll back
up to read what's at the beginning, Doesn't seem right though.

Cheers - Kirk
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default String in text box

Kirk,
Doesn't this work ?

Private Sub CommandButton1_Click()

With TextBox1
.SetFocus
.SelStart = 0
End With

End Sub

NickHK

"kirkm" wrote in message
...
On Tue, 6 Mar 2007 17:25:26 +0800, "NickHK"
wrote:

Kirk,
Check out the .SelStart, .SelText .SelLength properties of the TextBox.


Hi, I read the Help on those (which didn't make much sense to me).

Tried a few things but nothing worked as hoped - or gave errors.
Stuff about SetFocus and other complications.

Suppose I'll just have to leave the cursor at the end and scroll back
up to read what's at the beginning, Doesn't seem right though.

Cheers - Kirk



  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 156
Default String in text box

On Wed, 7 Mar 2007 17:47:31 +0800, "NickHK"
wrote:

Kirk,
Doesn't this work ?

Private Sub CommandButton1_Click()

With TextBox1
.SetFocus
.SelStart = 0
End With

End Sub


Thanks Nick. All sorted now.

Cheers - Kirk
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
Text string to Numeric string Manikandan[_2_] Excel Discussion (Misc queries) 2 March 12th 09 08:55 AM
Nested formula to search a text string and return specific text Barbie Excel Worksheet Functions 10 February 21st 09 07:40 AM
Change 3 letter text string to a number string Pete Excel Discussion (Misc queries) 3 December 31st 07 07:47 PM
Splitting a text string into string and number mcambrose Excel Discussion (Misc queries) 4 February 21st 06 03:47 PM
want to remove all text characters equal to one character in length from text string [email protected] Excel Worksheet Functions 1 April 18th 05 12:25 AM


All times are GMT +1. The time now is 01:37 AM.

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"