ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Cancel buttons in Msgbox (https://www.excelbanter.com/excel-programming/277505-cancel-buttons-msgbox.html)

patrick molloy

Cancel buttons in Msgbox
 

Sub MessageBoxCheck()
If MsgBox("Continue?", vbQuestion + _
vbOKCancel, "Test") = vbCancel Then
MsgBox "Cancelled"
Exit Sub
End If
'
' you process here
'
MsgBox "Processed"
End Sub


Patrick Molloy
Microsoft Excel MVP

-----Original Message-----
I am having one of the brain-blanks. For some reason,
when you click the cancel button on several of my msg or
input boxes, it does not cancel the function, but

returns
to the loop. What do I do to get the cancel buttons to
function normally...?
.



All times are GMT +1. The time now is 12:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com