$$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 excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Close.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Msg Box
Hi, Look Attached... *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* On Fri, Sep 9, 2011 at 4:43 PM, Mr Excellent suryaprasad...@gmail.comwrote: 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 excel-macros@googlegroups.com 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 excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Close.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Msg Box
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 suryaprasad...@gmail.com To: excel-macros@googlegroups.com 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 excel-macros@googlegroups.com 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 excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Msg Box
Dear Surya, use simple...for excel sheet.. ** *Private Sub cmdClose_Click() ActiveWorkbook.Close True* *End Sub* for userform.. *Private *Sub* CommandButton1_Click() If MsgBox(Do you want to Save the details, vbQuestion + vbOKCancel) = vbYes Then End If Unload Me End Sub* -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Fri, Sep 9, 2011 at 4:43 PM, Mr Excellent suryaprasad...@gmail.comwrote: 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 excel-macros@googlegroups.com 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 excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel