I want my macro to continue if the yes no msg box is not triggered.
currently i have set a yes no msg box in my macro. for example if the value in cell A1 is more than 100 then the msg box pops up and says “the value is above 100, do you wish to continue?” if i press no it exits sub and if i press yes the rest of the code executes. cool everything works good, but the issue is, when the value in cell A1 is less than 100 and i run the macro, just nothing happens. i want the macro to continue also if the value in cell A1 is below 100.
thank you

i am using the following code for msg box

If Range("E14").Value = "EID Already Exist" Then
                 AnswerYes = MsgBox("EID Already Exist Do you want to go ON?", vbQuestion + vbYesNo, "User Repsonse")

If AnswerYes = vbYes Then

rest of the code 

else
exit sub