select range as in the first range without using scroll bar based on combobox on form

thanks ,but the most important should move the range as if it is in first range when I select name from combobox. I don't want using scrollbar to see the range if I have multiple ranges.

According to your attachment a starter VBA procedure to paste only to the UserForm1 module :

PHP Code: 

Private Sub CommandButton1_Click()
        Dim Rf As Range, R&, C%
        If ComboBox1 = "" Then Beep: Exit Sub
    With ActiveSheet.UsedRange.Columns(9)
        Set Rf = .Find(ComboBox1, , xlValues, 1)
     If Not Rf Is Nothing Then
        R = Rf.Row
     Do
         If Rf.Row > 1 Then
            If Rf(0) = "NAME" Then
                Windows(1).ScrollColumn = 8:  Windows(1).ScrollRow = Rf.Row
                Set Rf = Rf.End(xlDown)
                For C = 1 To 4:  Controls("Textbox" & C) = Rf(1, C).Text:  Next
                Exit Do
            End If
         End If
        Set Rf = .FindNext(Rf)
     Loop Until Rf.Row = R
        Set Rf = Nothing
     End If
    End With
End Sub 


► Do you like it ? ► ► So thanks to click on bottom left star icon « ★ Add Reputation » ! ◄ ◄

Excellent Marc !
this is exactly what I want it .
thank you so much .