Max,

You need to past this macro into the workheet code for that sheet.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$D$9" Then
Me.Range("D10:d12").ClearContents
End If
End Sub
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"max power" wrote:

i need a macro that will make a cell value blank when another cell is changed.

i cant use a formula because the cell that needs to be blank has data
validation on it and so takes entry from a list

short example of what i want is:

if cell D9 is changed in any way then cells D10,D11 and D12 will be cleared
( = "")

please help