Pull Data based on a date criteria

Originally Posted by Nolesphan30

Right now on my agent summary page I have a drop list which pulls all data associated with the user from the database sheet.

How can I also add two drop list that allows me to select a date criteria? Like Between date 01/01/08 and 01/31/08?

See attached.


Thanks,
JG

Very Nice workbook,
Try a couple of date pickers, they are the same size as the combo boxes, but when you click the drop down arrow, a calendar appears below it,
right click on the UserForm toolbox and select additional controls find Microsoft date and time picker, check the box and then OK,
you should now have it on your toolbox, place it on your userform
BTW
you can have the command button insert the values instead of calling another code

Private Sub CommandButton1_Click()
    Dim a As Range
    Dim b As Range
    Dim c As Range
    Dim d As Range
    Dim i As Range
    Dim e As String
    Set a = Range("b65536").End(xlUp).Offset(1, 0)
    Set b = Range("e65536").End(xlUp).Offset(1, 0)
    Set c = Range("f65536").End(xlUp).Offset(1, 0)
    Set d = Range("g65536").End(xlUp).Offset(1, 0)
    Set i = Range("a65536").End(xlUp).Offset(1, 0)
    e = Application.WorksheetFunction. _
        VLookup(ComboBox1, Range("L2:M45"), 2, False)
    With Worksheets("Database")
        a = ComboBox1
        b = ComboBox2
        c = ComboBox3
        d = ComboBox4
        i = e
    End With
End Sub