ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   String in text box (https://www.excelbanter.com/excel-programming/384609-string-text-box.html)

kirkm[_6_]

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

NickHK

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




kirkm[_6_]

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

NickHK

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




kirkm[_6_]

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


All times are GMT +1. The time now is 10:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com