hi
I have data in sheet data . indeed I 've found many codes to how shows data in listbox when search the customers . but the challenge is how calculate the balance . it's not like normal way . so I put the expected result in sheet LISTBOX when search customer SAMMER how should be in listbox and show the TOTAL VALUES DEBIT (TEXTBOX2) by summing the values in COL DEBIT and the same thing TOTAL values CREDIT(TEXTBOX3) but the BALANCE(TEXTBOX4) should subtract DEBIT (TEXTBOX2) from CREDIT(TEXTBOX3) if the textbox3 . when gives minus value should highlight by red color and the COL BALANCE in listbox should show like what I put in sheet LISTBOX. see the formula how should be in last COLUMN BALANCE . with considering there is no sheet LIST at all just to understand how should show in listbox. last thing I want when run user form show all of data as in sheet data and calculate the values in textbox2,3,4
thanks in advance
Bookmarks