Another one:

Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
If not (intersect(target, me.range("c5") is nothing) then
me.range("f5,f7,c7").clearcontents
end if
if not (intersect(target, me.range("c8") is nothing) then
me.range("F8").clearcontents
end if
End Sub




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.

--

Dave Peterson