Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question about the TextBox control
Windows XP SP2
Excel 2002 SP3 I have a textbox on a userform, and it gets populated with road names. I use the vbCrLf keyword to put each road name on a new line in the textbox. If the road name list gets too long, a vertical scrollbar is added to the control. What I want to do is on those occasions when a scrollbar is added, is to have the scrollbar slider positioned all the way at the top when all is said and done. This way the first road name is always visible. FYI, the userform isn't shown until the very end. -gk- |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question about the TextBox control
I suppose you have good reason to use a textbox to mimic a listbox....
Anyway, look into the various .Selxxx properties of the textbox. You cannot tell (easily) when the scroll bar appears, so just set ..SelStart=0 each time you add to the textbox. NickHK "Tox" wrote in message ... Windows XP SP2 Excel 2002 SP3 I have a textbox on a userform, and it gets populated with road names. I use the vbCrLf keyword to put each road name on a new line in the textbox. If the road name list gets too long, a vertical scrollbar is added to the control. What I want to do is on those occasions when a scrollbar is added, is to have the scrollbar slider positioned all the way at the top when all is said and done. This way the first road name is always visible. FYI, the userform isn't shown until the very end. -gk- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to control TextBox ? | Excel Programming | |||
How to move cursor from one textbox control to another textbox con | Excel Programming | |||
How to move cursor from one textbox control to another textbox con | Excel Programming | |||
Set Focus Problem for textbox control on multipage control | Excel Programming | |||
ActiveX Control (TextBox) question | Excel Programming |