Need a way to sort through already entered data via my userform.

[kccushman]

So I have a userform that populates a table, but I would really like two things added to my userform. First, I'd like it to be able to move between the entries via "prev" and "next" buttons. Then I'd like a way to open a specific entry of data. Anyone have suggestions or ideas of how to go about that and the code they'd use?

I'm very junior in my excel vba and userform experience, so any help would be greatly appreciated.

Thank you!

 

[NickRed18]

Hey there kccushman,

So first off, when you say you want to move between entries do you mean through a Combo box in the userform? Or when you say userform, are you using userform components on an excel sheet - you want buttons to move up and down the table.

I'm basing my reply off the former (move between entires in a combo box), so let me know if I was mistaken. Here is how to use 2 buttons to move to the next item and the previous item for a ComboBox:

Private Sub UserForm_Activate()
    Dim i As Integer         'integer used to fill the ComboBox
    Dim n As Integer        'The number of rows in your table
    
    'code for finding n
    
    For i = 1 To n
        UserForm1.ComboBox1.AddItem Worksheets("Sheet1").Cells(i, 1)
    Next i
End Sub


Private Sub NextButton_Click()
    Dim a As Integer


    a = UserForm1.ComboBox1.ListIndex
    If a > n - 2 Then
    Else
        UserForm1.ComboBox1.ListIndex = UserForm1.ComboBox1.ListIndex + 1
    End If
End Sub


Private Sub PrevButton_Click()
    Dim a As Integer


    a = UserForm1.ComboBox1.ListIndex
    If a < 1 Then
    Else
        UserForm1.ComboBox1.ListIndex = UserForm1.ComboBox1.ListIndex - 1
    End If
End Sub

 

[kccushman]

Sorry for the delayed reply! That's great, but it's the bottom one. I have a userform that has a combination of comboboxes, text boxes, radio buttons, etc. that feed into a master excel spreadsheet. From there, I would love to be able to do two things. First, scroll through previous entries in the userform from a previous and next button. then, I'd like a search or find box or a way to select one of the rows entries to open that data into the userform. Does that help?