Auto Scroll When Users Tab To Next TextBox?

[indi visual]

I was hoping to use a bit of code to auto click down one notch on the scrollbar -for each time I tab jump to the next text box on my userform. Just thought it'd be easier than having to stop typing just to scroll the scrollbar down further for more room.

 

[Luke M]

I'm not exactly sure how to do that. Maybe you could use some type of field_select event to cause the scroll to change? Alternatively, can you make the form bigger so scrolling is not needed?


BTW, I don't think the issue is that you've been "black listed", I think you're just asking more difficult questions. Questions that either a) we just don't know the answer to, or b) are very hard to answer w/o seeing the exact workbook. Just to allay any paranoia...

=)

 

[indi visual]

Resolved : )


Private Sub TextBox1_Enter()

ScrollBar1.Value = 585 '''adjust value as needed

End Sub


Thanks Luke