Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Can someone please explain why Application.Quit is ignored
here and VBA goes on working? This is on Excel 97. My code is similar to this: Sub My_subrtn() Application.DisplayAlerts = False Dim x As Integer x = 3 If x 2 Then Application.Quit End If MsgBox "VBA is still running" MsgBox "VBA is still running" MsgBox "VBA is still running" End Sub Here, Application.Quit is ignored(?) and all the MsgBoxes are executed. I googled this and found that a DoEvents after the Application.Quit statement solves the problem. Does anyone know why? I ask because I always thought that each statement in the program must be executed before the next statement enters the program. The above behavior throws that out the window. In this case for example, do I need a DoEvents statement after x = 3 in order to make sure the If statement doesn't execute first? In other words what is it that makes Application.Quit different? Thank you for your time. Andy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Application.Quit Does not Close the Application | Excel Programming | |||
difference application.quit & application.close | Excel Programming | |||
macro to close excel application other than application.quit | Excel Programming | |||
application.quit will not shut off application | Excel Programming | |||
Quit Application | Excel Programming |