macro help please

[max power]

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

 

[Corey]

Try using the :
Private Sub Worksheet_SelectionChange(ByVal Target As Range)

End Sub

function

 

[JLatham]

See my reply with code in your posting in GQ.