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.