Hi experts ,
first sorry I don't attach file because I have sensitive data . I no know if any body could help me without attaching .
my problem when I copy values from userform doesn't change calculation where the cell contains formulas actually I made sure from setting CALCULATION & TEXT TO COLUMN seems every thing is ok !
so I copy values from textboxes and paste in cells E19:E25 and the formula will be E26=sum(E19:E26) and E28=E26+E27 . when change the values in cells E19:E25 just show zero in cells E26,E28 I have to use manually by press inside cell to show the values . is there any way to fix this dilemma ?