populate balance on userform if existed in sheet and missed in another

[abdelfattah]

Hi,
this works for jindon and I hope to getting chance help again .

I would add another condition to adjusting code for Private Sub GetData()
what I search for it if the name is new in balance first of duration sheet and is not existed in sheet1 should show in listbox1 when select all from combobox or when clear in combobox .as to select the name will show as code does it .
when there is new name in balance first of duration sheet and contains minus value then should show plus value in credit column(6) in listbox1 and if new name in balance first of duration sheet and contains plus value then should show plus value in debit column(5) as marked in picture.
thanks in advanced.