if you mean how to stop the form from closing....

Code:
if vbNo then
  e.Cancel  = True
endif
however you really need to take a close look at your logic.....

vb Code:
  1. If vbYes Then
  2.                 Close()
  3.                 If vbNo Then
  4.                 End If
  5.             End If
using that code, the check for vbNo will no be done if No is selected.