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

I couldn't duplicate the loss of formatting in xl2003 and my simple userform.

But any formula in that cell will be lost. Excel will plop that value into the
cell--just like typing a new value removes any existing value or formula.

A question about the formatting problem...

What are you typing into the textbox? Maybe excel sees it as text. The cell is
still formatted as Currency, but the value is text, so the number formatting
doesn't apply.

If that's the case, maybe you can clean up the value and assign the value to
that cell--and drop the .rowsource completely.

K11ngy wrote:

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

--

Dave Peterson