Hello
When cell B1 changes, the corresponding codes are running
Likewise, when I change Cell b2, the relevant code does not work.
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, [B1]) Is Nothing Then Exit Sub
Range("B2") = "TL"
Range("B3") = "YOK"
Range("A75") = ""
If Intersect(Target, [B2]) Is Nothing Then Exit Sub
Range("B3") = "YOK"
End Sub
Bookmarks