| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Msg Box With Exit Sub - How to quit application
I would like for the application to stop processing if the user selects
vbCancel. Right now, the application does not exit & continues to bug out since the Sub stops processing. Thanks for any feedback! Dim Ans As String Ans = MsgBox("Data columns must occur in the following order: " & vbNewLine & vbNewLine & _ "User Name (A)" & vbNewLine & _ "Set of Books (B)" & vbNewLine & _ "Click OK to continue. Click Cancel to correct data.", vbOKCancel + vbQuestion, "Confirm Column Order") If Ans = vbCancel Then Exit Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Application.quit | Excel Programming | |||
| difference application.quit & application.close | Excel Programming | |||
| Exit-quit sub | Excel Programming | |||
| macro to close excel application other than application.quit | Excel Programming | |||
| application.quit will not shut off application | Excel Programming | |||
Threaded Mode
