hi
I attach some pictures for six cases inside the sheet how should show in listbox on userform . the code populates data based on column (4) in listbox. now I would make it more flexible to sort based on date for item is written in textbox1 .
case1 when run the userform populate data in listbox
case2 I want sort data based on select last date after write item in textbox1 based on column 4 in listbox
case3 I want sort data based on select old date after write item in textbox1 based on column 4 in listbox
case4 I want sort data based on select reset after write item in textbox1 based on column 4 in listbox should show whether last or old date together
case 5 I want sort data based on select month and combobox for specific month after write item in textbox1 based on column 4 in listbox
note: I've found I do not need optionbutton MONTH . just depends on combobox1 to select month
case6 I want sort data based on write the date (from,to) in textbox2,3 after write item in textbox1 based on column 4 in listbox
thanks in advance
Bookmarks