search button in userform

[neithan]

is it possible to search by date range and the result will show in textboxes without using datagrid/listbox? i have two rows of 3 textboxes first row should show only the result for the first person, and in the second row of textboxes will show only the result for second person. if date person is not in the date range the equivalent row of textboxes will be blank. i'm new in the userform. Thanks

 

[neithan]

Private Sub cmdsearch_Click()
Dim totalrow As Long, x As Long


totalrow = Sheet3.Range("A1").CurrentRegion.Rows.Count
For currentrow = 2 To totalrow
If Trim(cmbmonth) = Trim(Cells(currentrow, 2)) And Trim(txtyear) = Trim(Cells(currentrow, 3)) And Trim(Cells(currentrow, 1) = "Bernadette") Then
lblc1bernadette = Cells(currentrow, 10)
lblc2bernadette = Cells(currentrow, 11)


If Trim(cmbmonth) = Trim(Cells(currentrow, 2)) And Trim(txtyear) = Trim(Cells(currentrow, 3)) And Trim(Cells(currentrow, 1) = "April") Then
lblc1april = Cells(currentrow, 10)
lblc2april = Cells(currentrow, 11)








End If
End If


Next currentrow
End Sub