Loop through ranges inside condition

[AlaaEddin]

Hello There,

I have the following code:

Private Sub Worksheet_Change(ByVal Target As Range)    

    If Target.Address = "$B$12" Then
        Range("C12").Value = "Please Select..."
    End If
    If Target.Address = "$C$12" Then
        Range("D12").Value = "Please Select..."
    End If
    
    If Target.Address = "$B$13" Then
        Range("C13").Value = "Please Select..."
    End If
    If Target.Address = "$C$13" Then
        Range("D13").Value = "Please Select..."
    End If

    If Target.Address = "$B$14" Then
        Range("C14").Value = "Please Select..."
    End If
    If Target.Address = "$C$14" Then
        Range("D14").Value = "Please Select..."
    End If

End Sub

so what I need is too loop this so I don't need to define each row individually
Thanks in advance.

 

[mikerickson]

Perhaps something like this, with the row limits set as needed.

With Target
    If .Cells.Count = 1 Then
        If .Column = 2 Or .Column = 3 Then
            If 12 <= .Row And .Row <= 14 Then
                Application.EnableEvents = False
                .Offset(0,1).Value = "Please Select..."
                Application.EnableEvents = True
            End If
        End If
    End IF
End With

 

[AlaaEddin]

The code does work but there's a problem that when the value of D12 isn't changed when the value of B12 changed so I need this to be performed also the count of columns and rows is going to be more than this so I need you to clarify how I can customize this formula to match my needs.

Thanks you so much your help is really appreciated