Yes/No MsgBox - Return to Form

G

Guest

I have a simple msgbox with vbYesNo for an "upon close" event. When Yes is clicked it closes the form, which is fine. But, when No is clicked I want it to return to the form instead of closing it. How do I do this?
 
F

fredg

I have a simple msgbox with vbYesNo for an "upon close" event. When Yes is clicked it closes the form, which is fine. But, when No is clicked I want it to return to the form instead of closing it. How do I do this?
Click to expand...

The Close event is not the place to do this.
Use the Form's UnLoad event:

Cancel = MsgBox("Are you sure?",vbYesNo,"Closing Form") = vbNo
 
G

Guest

Thank you so much! It works great now.

fredg said:
The Close event is not the place to do this.
Use the Form's UnLoad event:

Cancel = MsgBox("Are you sure?",vbYesNo,"Closing Form") = vbNo
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save prompt is not working 1
Yes/No Options on a MsgBox 6
Excel Message box with days of month & date. 1
Before Update 3
Excel Providing user message when RED X clicked & properly closing application. 2
Excel Is it possible to ask a question within a question? 0
Solicit and act on user choice 2
Give Null value and suppress error 2

Top