MsgBox vbYesNo not working

[PCTech]

This code will bring up the message box but if I click on the yes, I got no results. Will someone please help me figure this out? It is suppose to put a "yes" in AL if I click yes in the message box.

Private Sub Worksheet_Change(ByVal Target As Range)
Dim myLabel As VbMsgBoxResult

i = ActiveCell.Row

If Range("AK" & i) = 1 Then

myLabel = MsgBox("Do you need a BARCODE LABEL", vbYesNo Or vbQuestion, "Labels")
    If myLabel = vbNo Then Exit Sub

End If
    If myLabel = ybYes Then
    Range("AL" & i) = "yes"
    
End If
End Sub

 

[Smitty]

Duplicate.

Please stick to your original post.

Smitty