Clear cell value if another cell is blank

[cmb80]

Hi there, using VBA i'd like to clear the value in cell A2 - when There is nothing (cell is blank) in D4.

Please advise the code needed on the worksheet to trigger this

[Olly]

try:

Please Login or Register  to view this content.

[Richard Buttrey]

Hi,

You don't say what event should trigger this code?

i.e. a button click, the sheet Activate event, the sheet Selection Change (presumably D4) event, The Sheet Change Event.. or several others.

Whatever the event the code will include

Please Login or Register  to view this content.

[cmb80]

Thanks Olly, that works