Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text string to Numeric string | Excel Discussion (Misc queries) | |||
Nested formula to search a text string and return specific text | Excel Worksheet Functions | |||
Change 3 letter text string to a number string | Excel Discussion (Misc queries) | |||
Splitting a text string into string and number | Excel Discussion (Misc queries) | |||
want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions |