If the user can type into the cell, then you cannot put a formula in the
cell also (it will be overwritten by the user's entry). The only way to do
what you want is through an event procedure. In order to give you the code
you will need, we need some more information. Are you interested in cells
C17 and C21 only? Or is this a functionality you need across multiple
columns? If multiple columns, which ones (start column, end column)? Always
rows 17 and 21, or do other rows need to react to the value typed into C17?

Rick


"HH" wrote in message
. ..
Rick,
C21 is a general text cell where the user can type comments. There is no
formula in this cell now.

"Rick Rothstein (MVP - VB)" wrote in
message ...
What is in C21 now? By that I mean, does it contain a formula which
displays text (if so, tell us the formula) or does it contain text typed
in by the user?

Rick


"HH" wrote in message
...
Maybe I was not clear enough - or maybe I don't understand. I'll try
again..

If I put a value less than 1980 in cell C17, I would like a text
statement added to cell C21. This added text statement would say
"Construction material may contain lead." There may already be a text
statement in C21 so the new statement would be added at the end of
whatever is already in the cell.
What I have come up with is: =If (C171980,C21="Construction material
may contain lead.","") I think this would delete whatever is already
in C21 and replace the Consturction material...statement. But even if
it would work - I don't know where to add the =if statement.
Thanks

"HH" wrote in message
...
Based on value in C15 I want to have a text statement added to cell
B21. I would like this to be put at the end of whatever is already in
B21 - not just replace the cell content.

Need help with the code - and where it would go.

Thanks