Automatically change cell value when another cells value change to 0

[OX_2005]

I am still very new to VBA and I am struggling with this. Any assistance will be helpful.

When the value in Column "M" changes to "0" I am wanting the values in columns "E:I" to automatically change to "FALSE" so that the check box will uncheck. I can get it do work with just 1 row of data but I am trying to get it to do a Range of rows (3 to 42).

This is the current code I put together

This is the Doc I am working with

 

[OX_2005]

So I have a follow-up question. If I wanted to have it do 2 different things when something is delete is that possible? Current code is what you gave me with a couple Cell locations. So if when I delete whats in cell A and it does the code below can I also have it delete the contents of cells B:E?



Private Sub Worksheet_Change(ByVal Target As Range)

Dim rng As Range
Dim cell As Range

' See if any values in column M were updated
Set rng = Intersect(Target, Range("A3:A42"))

' Exit if no cells in that range were updated
If rng Is Nothing Then Exit Sub

' Loop through cells in watched range can check their values
Application.EnableEvents = False
For Each cell In rng
' See if value is 0
If cell.Value = "" Then
' Update columns E through I
Range(Cells(cell.Row, "N"), Cells(cell.Row, "R")).Value = "FALSE"
End If
Next cell

Application.EnableEvents = True

End Sub

 

[Joe4]

To delete the contents of cells B:E would just look something like:

Range(Cells(cell.Row, "B"), Cells(cell.Row, "E")).ClearContents

 

[OX_2005]

To delete the contents of cells B:E would just look something like:

Range(Cells(cell.Row, "B"), Cells(cell.Row, "E")).ClearContents

Thank you I was so over thinking this. I want to thank you for all your help. I have hopefully finished this document now.

 

[Joe4]

You are welcome!