I think I see.

Have you tried setting the ControlSource property of the textboxes to the
cells, this will automatically update.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Greg B..." wrote in message
...
Sorry again,

Ok I have userform1

on this form I have

textbox 1 which is what the user inputs a number

this is linked to cell a1 on sheet1

textbox2 this shows the total in range c1 on sheet 1 (this only show
the
amount when loaded only.)

textbox3 this is like textbox 2

textbox 4 shows an average of textbox2 divided by textbox3

I hope this is clearer

Thanks again Greg