invoice again

[Guest]

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

 

[Stefan B Rusynko]

Wrong newsgroup - try an Excel newsgroup
This is a FrontPage newsgroup

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


|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
|