Change Cell Value based on Value on other cell

[arthmalaca]

Hi,

Please help me. I'm trying to create a checklist.

I need to change the value in cells K25 and K27 to N/A when the value of cell K22 is Correctly

I used the code below before but it does not work

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Range("K22").Value = "Correctly" Then
Range("K25", "K27").Value = "N/A"
End If
End Sub

Can somebody help me, please. I'm quite new in VBA codes, so please bear with me.

 

[Michael M]

try

Private Sub Worksheet_Change(ByVal Target As Range)
If Range("K22").Value = "Correctly" Then
Application.EnableEvents = False
    Range("K25,K27").Value = "N/A"
Application.EnableEvents = True
End If
End Sub