listbox Additem between 2 date range userform

Hi,
Good day, i'm just new to this forum so please do correct me i'm I violate some rules on how to post questions. Here goes my issue with my excel file
i'm trying to filter data using dates.
what i'm trying to do is input a date on a textbox.
Start date and end date.
i'm having issue displaying it on my listbox
and the date format as well is in MM/DD/YYYY. Is there a possible way to change the date format to DD/MM/YYYY?

Thank you.
Here is my codes.

CODE HERE

[COLOR=#333333]Private Sub txtDate_Change()[/COLOR]
[COLOR=#333333]On Error Resume Next[/COLOR]
[COLOR=#333333]Me.txtDate = CDate(Me.txtDate)[/COLOR]
[COLOR=#333333]End Sub[/COLOR]


[COLOR=#333333]Private Sub endDate_Change()[/COLOR]


[COLOR=#333333]Dim ws As Worksheet[/COLOR]
[COLOR=#333333]Dim i As Long[/COLOR]
[COLOR=#333333]On Error Resume Next[/COLOR]
[COLOR=#333333]Me.endDate = CDate(Me.endDate)[/COLOR]
[COLOR=#333333]Me.ListBox1.Clear[/COLOR]


[COLOR=#333333]For i = 2 To Application.WorksheetFunction.CountA(Sheet2.Range("D:D"))[/COLOR]
[COLOR=#333333]If Sheet2.Cells(i, 1).Value >= CDate(Me.txtDate.Text) And _[/COLOR]
[COLOR=#333333]Sheet2.Cells(i, 1).Value <= CDate(Me.endDate.Text) Then[/COLOR]
[COLOR=#333333]Me.ListBox1.AddItem Sheet2.Cells(i, 1).Value[/COLOR]
[COLOR=#333333]Me.ListBox1.List(ListBox1.ListCount - 1, 1) = Sheet2.Cells(i, 2).Value[/COLOR]
[COLOR=#333333]Me.ListBox1.List(ListBox1.ListCount - 1, 2) = Sheet2.Cells(i, 3).Value[/COLOR]
[COLOR=#333333]Me.ListBox1.List(ListBox1.ListCount - 1, 3) = Sheet2.Cells(i, 4).Value[/COLOR]
[COLOR=#333333]Me.ListBox1.List(ListBox1.ListCount - 1, 4) = Sheet2.Cells(i, 5).Value[/COLOR]
[COLOR=#333333]End If[/COLOR]
[COLOR=#333333]Next i[/COLOR]








[COLOR=#333333]End Sub[/COLOR]

hoping for your help.

Re: listbox Additem between 2 date range userform

Quote from royUK;800664

Can you attach an example workbook.

Also, when posting code please don't use other tags within the code.

Here is my sample workbook.
Sorry for violating the rules. it won't happen again next time.

Re: listbox Additem between 2 date range userform

Quote from royUK;800678

It's not really, violating the rules. Mixing the tags doesn't work.

I'll take a look later.

Thanks for spending some time

Re: listbox Additem between 2 date range userform

Quote from royUK;800690

I've added an error handler to each of the date textboxes and when the user clicks on an entry in the ListBox the other controls are populated

Hi,
Yes it is working when searching using the date.
But when searching using the name it is no longer working.
Where will I input the code for the search to work using name.
previously when searching for the name it was working.

Re: listbox Additem between 2 date range userform

Quote from royUK;800730

You never mentioned searching by name. How do want to search by Name? Still between the two dates?

Hi,

Other options for searching is by name. It can either be by date range or by name. so if I have 3 same names added. Once I search for it. all those 3 names will populate the listbox as well. and if I want to search by date range. same goes. it will populate the listbox within the range date.

Re: listbox Additem between 2 date range userform

Quote from royUK;800730

You never mentioned searching by name. How do want to search by Name? Still between the two dates?

i'm trying to search either by date range or by name. if i want to search for example weekly or monthly scores I will search by dates. but there are times that I just need to search all the same name. so that is the time I will search by name. Thanks