Clearing content in cell when value in other cells changes

[mikebowman]

Hi

I've just joined the Forum and this is my first post.

I found this code online and pasted into General / Declarations. It is designed to clear the contents of C4 and C12 whenever the value in C2 changes

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("C2")) Is Nothing Then
Range("C4").ClearContents
Range("C12").ClearContents
End If
End Sub

This works exactly as I want it too, but now I want to add another condition. That is to clear the contents of C12 if C4 changes i.e. I want both these to work in the same sheet.

Required behaviour:
if C2 changes, clear both C4 and C12
if C4 changes, clear C12 only

I'm not a VBA programmer and really not sure where to start. Any tips would be much appreciated!

Thanks!

[SjonR]

Please Login or Register  to view this content.

[xladept]

Try:

Please Login or Register  to view this content.

[Mumps1]

Try:

Please Login or Register  to view this content.

[mikebowman]

Hi

Many thanks for your help..

Unfortunately when I try this, I get the compile error 'End if without block if'

Any ideas?

Thanks

[mikebowman]

Hi

Thanks so much for this. It has worked a treat and does exactly what I want it to!

Cheers
Mike

[xladept]

Who are you thanking? If it's me then you're welcome!