Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text box Scroll bar position
Hello:
I would appreciate help with the following. I have created an user form with text box that contains about 3 paragraphs of text. I have set the scrollbar property to show vertical scroll bars. When I open the form, the scroll bar position is at the bottom i.e the last line of text is displayed in the text box. What can I do so that the scroll bar always starts at the top and the first line of text is displayed whenever the form is opened? TIA Vinay |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text box Scroll bar position
Try something like:
TextBox1.SelStart = 0 -- Jim Rech Excel MVP "Vinay" wrote in message om... | Hello: | I would appreciate help with the following. | | I have created an user form with text box that contains about 3 | paragraphs of text. I have set the scrollbar property to show vertical | scroll bars. | | When I open the form, the scroll bar position is at the bottom i.e the | last line of text is displayed in the text box. What can I do so that | the scroll bar always starts at the top and the first line of text is | displayed whenever the form is opened? | | TIA | | Vinay |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text box Scroll bar position
Vinay,
This should work: Private Sub UserForm_Initialize() Me.TextBox1.SelStart = 0 End Sub hth, Doug "Vinay" wrote in message om... Hello: I would appreciate help with the following. I have created an user form with text box that contains about 3 paragraphs of text. I have set the scrollbar property to show vertical scroll bars. When I open the form, the scroll bar position is at the bottom i.e the last line of text is displayed in the text box. What can I do so that the scroll bar always starts at the top and the first line of text is displayed whenever the form is opened? TIA Vinay |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
text position on a chart | Excel Discussion (Misc queries) | |||
Chart text position | Excel Discussion (Misc queries) | |||
Setting All Worksheets To The Same Scroll Position | Excel Worksheet Functions | |||
Vertical Scroll bar position in Text box | Excel Programming | |||
control scroll position | Excel Programming |