Control Scroll bar

[mcroozer]

I am building a form in Excel using textboxes with some VB behind them. I am new to this and I'm sure there is an easier way to build my forms but it's too late to turn around now.

I have 25 or so textboxes on the left side of the form. When I get to textbox 22, the focus is below the viewable screen. The scroll bar does not move with my tab order. If I tab a few more times, the focus is returned to the textboxes on the upper right of my form.

I need to get the scroll bar to move to the bottom when I reach the end of the screen and to the top when I go back up. Is this an Excel setting that I am missing or can I control the scrollbar with some VB? Thanks for your time - Mcroozer.

[Leith Ross]

Hello Mcroozer,

Here are the macros to move the scrollbar up and down.
____________________________

Please Login or Register  to view this content.

____________________________
Sincerely,
Leith Ross