filter data between two dates on Listbox userform

[sofas]

hello..Help us to add the ability to filter data between two dates on Listbox userform
Everything works fine, I just have to choose the first and last date from the combobox.

FormFiltreListBox9ComboBoxs

MediaFire is a simple to use free service that lets you put all your photos, documents, music, and video in a single place so you can access them anywhere and share them everywhere.

www.mediafire.com

 

[James006]

Hi,

You do have a ComboBox for your End Date ... but where exactly is your ComboBox for your StartDate ... or is it pre-defined ?

 

[sofas]

Hi,

You do have a ComboBox for your End Date ... but where exactly is your ComboBox for your StartDate ... or is it pre-defined ?

Hello. I have one for filtering data with the date condition. I want to change it so that I can filter between two dates. I added a new fin date combobox to select the last date

To get a combo box for the first date and another for the last date

 

[James006]

Hello,

Do you mean that, in your UserForm, Date is your combobox FROM ... and that Fin Date is your combobox TO ....???

 

[sofas]

Hello,

Do you mean that, in your UserForm, Date is your combobox FROM ... and that Fin Date is your combobox TO ....???

 

[netobraga]

Hi Sofas,

your sheet has a link between listbox and a table, could you try manipulate a filter of the table and after update the listbox... something like...

Sub filterData()
' filterData

ActiveSheet.ListObjects("Table2").Range.AutoFilter Field:=2, _
Criteria1:=">=" & DataInicio, _
Operator:=xlAnd, _
Criteria2:="<=" & DataFin

End Sub

 

[sofas]

Hi Sofas,

your sheet has a link between listbox and a table, could you try manipulate a filter of the table and after update the listbox... something like...

Sub filterData()
' filterData

ActiveSheet.ListObjects("Table2").Range.AutoFilter Field:=2, _
Criteria1:=">=" & DataInicio, _
Operator:=xlAnd, _
Criteria2:="<=" & DataFin

End Sub

Thank you for taking care of my request. The problem is that I am not an expert in programming. Can you add it to the attached file for the experiment