Chrissy,

The other way would be to stop events running - then I could stop the
standard events running - is there a way to do this?
I asked this onece before myself.
The answer is no.
About the only way around it is to set a flag and test for it in the first
line of code under the event you want to bypass.

John

Chrissy wrote:

Tom Ogilvy wrote
There is no automatic connection between cells and controls other than the
controlsource. So code is really the only option for harvesting values from
cells with formulas.

I think you would have to key off the calculate event in the worksheet -
however, if the only thing that would make the sums change is user entries
in your userform, then perhaps you could key off that.

I would be nice if there was a control which had a write control source property
and a read control source property. That way you could have three controls
where one was the total of the other two and the values are automatically
displayed and saved just because the user entered a value in a cell.

The other way would be to stop events running - then I could stop the
standard events running - is there a way to do this?

When talking about user, it is generally more helpful/clearer to say
userform rather than just form as form could refer to simulation of a paper
form on a worksheet or you could be talking about a form in VB.

Ok - will do from now on.

Chrissy.