I know of no other way.

"David Coleman" wrote in message
...
Is there a nicer way than this? This one I knew of but, with 32 text
boxes
that can affect the result one, it didn't seem the tidiest method.....

Thanks

David


"Rob van Gelder" wrote in message
...
Add the following code to the userform:

Private Sub TextBox1_AfterUpdate()
TextBox4.Text = Range("A10").Value
End Sub

Private Sub TextBox2_AfterUpdate()
TextBox4.Text = Range("A10").Value
End Sub

Private Sub TextBox3_AfterUpdate()
TextBox4.Text = Range("A10").Value
End Sub

Then set the Locked property on TextBox4 to True


"David Coleman" wrote in message
...
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).