ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Vertical Scroll bar position in Text box (https://www.excelbanter.com/excel-programming/284270-vertical-scroll-bar-position-text-box.html)

Maria[_6_]

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



Bill Manville

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



All times are GMT +1. The time now is 09:48 AM.

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