Code:
Private Sub cmdcancel_Click()
 MsgBox "Are you sure you want to exit program", vbQuestion + vbYesNo, "Confirm"
    Unload Me
End Sub
You need to query the user's response as you did here
Code:
If MsgBox("Is this the most economical alternative?", vbQuestion + vbYesNo, "Confirm") = vbYes Then
BTW you never did answer my question which was how does the user know that this is the most economical alternative?