CASE1 when select ALL from combobox1
CASE2 when select ALL from combobox1 and dates from textboxes
CASE3 when select name from combobox1 and dates from textboxes
CASE4 when select name from combobox1
CASE5 when no selected name from combobox1 and no dates from textboxes
CASE6 when no selected name from combobox1 and write dates in textboxes
when clear combobox1 will populate all of data and when clear dates from textboxes will populate all of data if combobox1 is empty
as to listbox2 the listbox2 merge amounts for data showing in listbox1 for columns 5,6 based on name column 2 and show result in listbox2 when select items from combobox1 or write dates in textboxes. ex: omar=2000+580000+1000+1000=584000 and when there is name in balance first of duration sheet then should add to amount where is merged and if the amount is plus then when add to amount where is merged in listbox should be in debit ex:mariam =-5000-(100+500000)=505100
so will be in kr picture
so you can keep all of cases in listbox1 as you writing is ok but the problem will be in listbx2
the new names should show in listbox2 when they are not existed in listbox1 then should brings from balance first of duration sheet.
no need to populate in listbox1 , no need select from combobox1 , because they are not movements in sheet1 so will show as total in listbox2.
listbox2 doesn't need dates because what show in listbox1 then will merge based on specific condition as I mentioned how should be in listbox2.
