Userform TextBox ControlSource overwritten

[maxscott]

Hi

I have a simple userform that has 3 textboxes - txt1, txt2 and txt3

txt1.controlsource="=$a$1"
txt2.controlsource="=$a$2"
txt3.controlsource="=$a$3"

on my worksheet I have formula in a3 = a1 + a2

If I then run my form and put some value in txt1 and txt2 then txt3 is calculated. 10 + 11 = 21 for example.

BUT a3 on my worksheet now has the value not the formula ie 21 not "=a1+a2".

How can I stop the formula in A3 being overwritten?

Thanks

[torachan]

you cannot have both - either the cell has a formula or you write a value to it - if you just want to see the calculated value of $a$3 write it back to a 'label.caption'

Using the ControlSource property means the cell value will be displayed whenever the form is called and changes will be written to the cell immediately.

[maxscott]

Thank you. Understood.