problem doesn't show calculation by formula when copy values from userform to sheet

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 ?

The values are being stamped to the sheet at text rather than numbers. You can fix this by adding .Value to the end of the lines of code that put the data on the sheet.

If you don't know how to do that, paste your code into a reply and we can show you where to add it.

BSB

Awsome !
it works excellently , this is what I look for it
many thanks buddy

Happy I could help

BSB