Hello There, I have the following Code and I want to loop through the following Code:
The idea of the code that if data validation list value changed the other cells whom are related to that list will replace what is inside it to "Please Select..." to start new selection so instead of copy and paste the code for 20 rows I need to loop it.
Regards.
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..."
Range("E12").Value = "Please Select..."
Range("F12").Value = "Please Select..."
Range("G12").Value = "Please Select..."
Range("H12").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..."
Range("E13").Value = "Please Select..."
Range("F13").Value = "Please Select..."
Range("G13").Value = "Please Select..."
Range("H13").Value = "Please Select..."
End If
End Sub
The idea of the code that if data validation list value changed the other cells whom are related to that list will replace what is inside it to "Please Select..." to start new selection so instead of copy and paste the code for 20 rows I need to loop it.
Regards.