Hi

I've a cell on a sheet (call it a10) that contains a forumla to sum various
other functions on the sheet

eg =a1*10+b1*20+c1*30

The values of a1, b1 & c1 are set on an userform by using
textbox??.controlsource = "a1" etc

Textbox4 needs to show the result of the formula in a10. Easy, I thought -
set textbox4.controlsource = "a10"

Whilst this works initially, as soon as the formula is re-calculated ('cos
the user changes a textbox) the value of textbox4 is stored in a10 (ie the
resultant value overwrites the formula). Therefore, no other changes are
ever reflected.

Is there a way to stop this? The user may change any one (or more or all)
of the values in the data entry textboxes and I'd like the calculated total
to always show in textbox4.

Thanks in advance

David


BTW, all the data entry text boxes are contained within a frame, the total
box is located outside of that frame on the userform. Textbox4 is not
enabled (I don't want the user changing the total manually).