Change a cell value when another cell changes
 

How do I change the value of a cell when another cell changes?
In other words, if the value of cell D12 changes I want the value in cell
E12 to be deleted.

Change a cell value when another cell changes
 

In worksheet code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Range("D12"), Target) Is Nothing Then
Else
Range("E12").Clear
End If
End Sub
--
Gary's Student


"wahamler" wrote:

How do I change the value of a cell when another cell changes?
In other words, if the value of cell D12 changes I want the value in cell
E12 to be deleted.

Change a cell value when another cell changes
 

If you know what the value in D12 is, you could use a formula in E12 to
display blank if D12 is not that pre-defined value.
example - if the value in D12 is 5 and the value in E12 is also 5 (but can
be whatever you want):

=IF(D12<5,"",5)

HTH,
Paul

"wahamler" wrote in message
...
How do I change the value of a cell when another cell changes?
In other words, if the value of cell D12 changes I want the value in cell
E12 to be deleted.