Clear value if cell changes
Hope this works for you...
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$C$5" Then
Range("F7").ClearContents
Range("F5").ClearContents
Range("F7").ClearContents
End If
End Sub
--
Tech Whiz Tom
MS Access / Excel Applications Analyst
"Kashyap" wrote:
Hi, I have in cell drop down validation in around 8 cells and all are inter
related..
So, when the value of C5 changes, I need the contents in F5, F7 & C7 to the
cleared.. and when value of when C8 changes, contents in F8 to the cleared..
Healp pls
All the above cell have in-cell drop down validation.
|