You should use:
Dim Result
Result = MsgBox("Do you want to Save the Details",vbYesNoCancel)
if (Result = vbYes) then Unload Me
or you could use something like:
select case Result
case vbYes
' Enter code to process when option is to Save Details
case vbNo
' Enter code to process when option is to NOT save details
case vbCancel
' Enter code to process if "Cancel" is selected (or msgbox is aborted)
End Select
Paul
-----------------------------------------
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-----------------------------------------
________________________________
From: Mr Excellent <[email protected]>
To: [email protected]
Sent: Fri, September 9, 2011 7:13:06 AM
Subject: $$Excel-Macros$$ Msg Box
Hi Group,
I have a form which has a Close button and a Code assgined to it as below:
Private Sub cmdClose_Click()
MsgBox "Do you want to Save the details", vbYesNoCancel
Unload Me
End Sub
But What i need is when i Click on "OK" button on the form should close or if i
click on "No" the Form should not close and If i click on Cancel then the Msg
box shud be disappeared.
Attached is the sheet
Please help
Thanks
Prasad.--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to [email protected]
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to [email protected]
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
