Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vertical Scroll bar position in Text box
Hello:
I would appreciate help with the following: I have a userform with a text box which has a vertical scroll bar. When I open the form, I find that the vertical scroll bar position is somewhat midway between top & bottom. This results in the first line of text not be visible right away (of course on using the scroll bar I can go to the top). To the user the text message is somewhat confusing since it does not display the first line Is there a way to always open the form with the vertical scroll bar in the topmost position Thanks a lot -- Maria |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vertical Scroll bar position in Text box
Maria wrote:
Is there a way to always open the form with the vertical scroll bar in the topmost position Try Private Sub UserForm_Initialize() TextBox1.SelStart = 0 TextBox1.SelLength = 0 End Sub Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - reply in newsgroup |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Position vertical axis | Charts and Charting in Excel | |||
position of vertical axis | Charts and Charting in Excel | |||
Finding the position of the i-th non blank cell in a vertical range | Excel Worksheet Functions | |||
Multiple charts in one big chart -- how to rotate to vertical position? | Charts and Charting in Excel | |||
control scroll position | Excel Programming |