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.

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.

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" <(E-Mail Removed)> wrote in message
news75A9E44-C335-4414-85A7-(E-Mail Removed)...
> 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.