Changing another cell when the cell changes.

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

My eyesight's not that good.

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.

Try it like this:

Please Login or Register  to view this content.

You're welcome.




Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.