Add this code to your form.
VB Code:
  1. Private Sub UserForm_Terminate()

  2.     Call cmdCancel_Click

  3. End Sub