Auto delete cell content

[daidipya]

HI
I have a worksheet wherein at cell C8 i have put a validation as
follows
in case the value at B8 is more than zero then only any value in the
cell C8 can be fed.

The same is working , however in case i change the value at cell B8
from any number to zero the values at cell C8 does not get deleted.

does any body knows how to tackle this

 

[Dave Peterson]

Data|Validation isn't retroactive--if you change the rules, then the existing
value isn't validated.

And if you want to actually clear the second cell, you're going to have to use a
macro--maybe an event macro like this:

Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
Dim myCell As Range
Set myCell = Me.Range("a1")
If Intersect(Target, myCell) Is Nothing Then Exit Sub

If IsEmpty(myCell.Value) Then
Application.EnableEvents = False
me.range("B1").Value = ""
Application.EnableEvents = True
End If

End Sub

If you want to try, I had my parent cell as A1 and my child as B1.

Rightclick on the worksheet tab that should have this behavior. Select view
code and paste this in (adjust those addresses). Then back to excel.