Updating the selected item from the listbox based on the last column of the row preceding

Hello
Everything works fine for me except for the last column in the list box. What I want when I choose a specific item from the list box and update its data is to reset the balance calculation for the selected item from the list box based on the row that precedes it for the balance column.
Let's take an example of the second row in the list box. In the first picture, the item is selected
In the second picture, the value of the fifth column of the selected element is changed, then the control button is pressed to update . In the third picture, it is marked in red. The value in the last column of the selected element has not changed. The fourth picture is right value where the value is taken from the row that precedes it and the equation is in this form 1233 + 1233 -100 = 2366 and should also update next rows for the same name to become 2366-2000=366 , 366-466=-100 as in last pictur
Any row that is modified when calculating in the last column must take the value from the row that precedes for the last column and add to the value of the fourth column and subtract it from the fifth column of the selected element.
But if you choose the first row, then the fourth column will be subtracted from the fifth column in case the first row is updated in the List Box.
Last thing I want implemnt the whole codes for two sheets based on selected sheet from combobox
I hope the idea is clear
thanks

thanks for your replying

Do you see that the 'BALANCE' column appears to have incorrect values?...

based on my file there is no error , let's take sheet TT
based on the picture can you tell me where is the error ,please ?
do you know how is calculate ?
every name repeated is under each other of them for the same name calculates individually without is relating for the others names .
based on your file I see this is wrong , where did you get it from ?
note: if you mean the wrong the other sheet , yes you're right , sorry that's because I captured picture to explain what I want and forgot changing again , also I updated the file and last picture after updated the selected row in list box also should updated next rows for the same name and the same way to calculation as in last picture where mark red color .

Let's see if this is what you're asking:

PHP Code: 

Private Sub CommandButton1_Click() ' <Add>
TextBox1 = Now
If Not toValidate Then Exit Sub
ListBox1.RowSource = ""
tbl.ListRows.Add
toRegister tbl.ListRows.Count
End Sub 


See if this helps you: Change the value you want and click the Modify button: See the resulting balance!