Solved: Change based upon a cell value

[khalid79m]

Change a cell based upon a change in a another cell,

if the cell value c6 changed , then c8 needs to be cleared.

so example c6 has the value john, and I use the drop down to select peter , then i want anything that was in c8 to cleared.

Can anyone help

[georgiboy]

Private Sub Worksheet_Change(ByVal Target As Range)

If Not Intersect(Target, Range("C6")) Is Nothing Then
Range("C8").ClearContents
End If

End Sub

goes in worksheet module.

[khalid79m]

thanks mate works well