T
TotallyConfused
I have a userform with this command button to exit. When user enters data
in form that data will be added to worksheet. When user clicks on this exit
button (cmd button 3) I get a message if you want to save form. I do not
want user to save form at all. I just want to unload form. How can I
suppress this? I just want to unload and not save form. I tried the
following but not working: Userform2 savechanges: = false; Userform2.close
save changes: = false. But it does not work. Can this be done?
Private Sub CommandButton3_Click()
If MsgBox("Do you want to Exit?", vbOKCancel, "Exit or Cancel??") = vbOK Then
'whatever you want to do
ActiveWorkbook.Close 'closes the workbook
Unload Me 'closes the form
End If
End Sub
in form that data will be added to worksheet. When user clicks on this exit
button (cmd button 3) I get a message if you want to save form. I do not
want user to save form at all. I just want to unload form. How can I
suppress this? I just want to unload and not save form. I tried the
following but not working: Userform2 savechanges: = false; Userform2.close
save changes: = false. But it does not work. Can this be done?
Private Sub CommandButton3_Click()
If MsgBox("Do you want to Exit?", vbOKCancel, "Exit or Cancel??") = vbOK Then
'whatever you want to do
ActiveWorkbook.Close 'closes the workbook
Unload Me 'closes the form
End If
End Sub