Scoll a form w/o scrollbar

[jrobin5881]

I have another Userform question. I have coding so that scroll bars appear and work fine on the right side of my form so that my users can scroll up and down by clicking and dragging the bar up and down.

How can I make my form scoll as my users tab from one textbox to the next? Or if the user just clicks on the form and drags it up or down without using the scrollbar on the right? What property would I play with?

 

[combo]

TabStop and tabOrder properties set TAB key behaviour. Scrolling is automatic, to keep active control visible.

As for the second topic, use Scroll event:

Private Sub UserForm_Scroll(ByVal ActionX As MSForms.fmScrollAction, ByVal ActionY As MSForms.fmScrollAction, ByVal RequestDx As Single, ByVal RequestDy As Single, ByVal ActualDx As MSForms.ReturnSingle, ByVal ActualDy As MSForms.ReturnSingle)
Dim msfTestedTB As MSForms.Control, msfTargetTB As MSForms.Control, Y As Single
Y = Me.ScrollHeight
If ActionY <> fmScrollActionFocusRequest Then
    For Each msfTestedTB In Me.Controls
        If TypeOf msfTestedTB Is MSForms.TextBox Then
            If (msfTestedTB.Top < Y) And (msfTestedTB.Top > Me.ScrollTop + ActualDy) Then
                Y = msfTestedTB.Top
                Set msfTargetTB = msfTestedTB
            End If
        End If
    Next
End If
If Not msfTargetTB Is Nothing Then msfTargetTB.SetFocus
End Sub

combo