I have Invoice which of course at the end totals up subtotal + vat i.e E21+e22

On the data entry user form I have created I have put a text box in and the
control source is the invoice total. It adds up ok on the first instance but
then when I change input data it makes the cell in worksheet revert back to
general format (Even though when I check the formatting it is still in
currency (It also loses its formula)


Any ideas?

Thanks

Steve