View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
max power max power is offline
external usenet poster
 
Posts: 15
Default urgent and desperate

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