[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 225
  • Last Modified:

Scroll bar default is top

Folks,
I have a large text box with a vertical scroll bar in a multi-line format.
When the text box opens I'd like it to open by default at the top and then scroll down, not up.
0
Frank Freese
Asked:
Frank Freese
  • 3
  • 2
1 Solution
 
etech0Commented:
What do you mean by "when the text  box opens"?
Doesn't it always default to the top?
0
 
Frank FreeseAuthor Commented:
I call a form that had the text box using a command button. When the form opens with the text box is there as well as the vertical scroll bar but the text box is not at the top. I've made sure that the property ScrollTop of the form set to zero.
0
 
etech0Commented:
Interesting - I would have to see a sample db to diagnose it...
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Frank FreeseAuthor Commented:
OK...here the worksheet with the form
Book1.xlsm
0
 
Ejgil HedegaardCommented:
Insert this in the userform code window

Private Sub UserForm_Initialize()
    Me.TextBox1.SelStart = 0
End Sub

Open in new window

0
 
Frank FreeseAuthor Commented:
thanks,
you nailed it!
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now