Close msgbox after making selection
in [Programming]
|
From: JLGWhiz on 31 Mar 2010 10:55 Hi Peter, In the version of xl03 that I am running, the msgbox goes away, whether or not ScreenUpdating is enabled. Is it different in xl07 + ? "Peter T" <peter_t(a)discussions> wrote in message news:uhrGDvM0KHA.5512(a)TK2MSFTNGP06.phx.gbl... > What you describe cannot and occur. I very much doubt you actually tested > the code you posted as an example, at least not exactly as written and > with nothing else. > > My guess is you are showing the msgbox with screenupdating disabled. The > msgbox will stay on the screen indefinitely until the screen is refreshed > (even DoEvents) or by re-enabling screenupdating. > > Be sure to temporarily disable screenupdating if/as necessary when showing > a msgbox. > > Regards, > Peter T > > The only thing that > "John Keith" <kd0gd(a)juno.com> wrote in message > news:o3m5r5dpb4p28chv941hjmflecglohug0i(a)4ax.com... >> >Is this a message box that was created with a UserForm? >> >> No >> >>> The standard message box automatically closes when a button is clicked. >>> If it is the >>>standard message box and is not closing, there could be a software >>>problem >>>in your system. Is this in Excel, if so, what version. >> >> Excel 2007/WinXP >> >> The message box window stays open until the next msgbox command is >> executed. >> >> I also just tried the following >> >> msgbox("Test") >> for i =1 to 100000000 >> a=1 >> next i >> msgbox("done") >> >> The loop has not completed yet and the first message box is still >> open. >> >> >> >> >> >> John Keith >> kd0gd(a)juno.com > >
From: Peter T on 31 Mar 2010 11:05 Try this Sub abc() ' run with alt-F8 Dim a 'Application.ScreenUpdating = False MsgBox ("Move me away from the centre of the screen") Application.ScreenUpdating = False For i = 1 To 100 a = 1 Next i MsgBox ("done") Application.ScreenUpdating = True End Sub Regards, Peter T "JLGWhiz" <JLGWhiz(a)cfl.rr.com> wrote in message news:%23VbmlIO0KHA.4168(a)TK2MSFTNGP02.phx.gbl... > Hi Peter, In the version of xl03 that I am running, the msgbox goes > away, whether or not ScreenUpdating is enabled. Is it different in xl07 + > ? > > > "Peter T" <peter_t(a)discussions> wrote in message > news:uhrGDvM0KHA.5512(a)TK2MSFTNGP06.phx.gbl... >> What you describe cannot and occur. I very much doubt you actually tested >> the code you posted as an example, at least not exactly as written and >> with nothing else. >> >> My guess is you are showing the msgbox with screenupdating disabled. The >> msgbox will stay on the screen indefinitely until the screen is refreshed >> (even DoEvents) or by re-enabling screenupdating. >> >> Be sure to temporarily disable screenupdating if/as necessary when >> showing a msgbox. >> >> Regards, >> Peter T >> >> The only thing that >> "John Keith" <kd0gd(a)juno.com> wrote in message >> news:o3m5r5dpb4p28chv941hjmflecglohug0i(a)4ax.com... >>> >Is this a message box that was created with a UserForm? >>> >>> No >>> >>>> The standard message box automatically closes when a button is clicked. >>>> If it is the >>>>standard message box and is not closing, there could be a software >>>>problem >>>>in your system. Is this in Excel, if so, what version. >>> >>> Excel 2007/WinXP >>> >>> The message box window stays open until the next msgbox command is >>> executed. >>> >>> I also just tried the following >>> >>> msgbox("Test") >>> for i =1 to 100000000 >>> a=1 >>> next i >>> msgbox("done") >>> >>> The loop has not completed yet and the first message box is still >>> open. >>> >>> >>> >>> >>> >>> John Keith >>> kd0gd(a)juno.com >> >> > >
From: Peter T on 31 Mar 2010 11:18 Forgot to mention I get same results in 2003 & 2007 Peter T "Peter T" <peter_t(a)discussions> wrote in message news:OQswiOO0KHA.776(a)TK2MSFTNGP04.phx.gbl... > Try this > > Sub abc() > ' run with alt-F8 > Dim a > > 'Application.ScreenUpdating = False > > MsgBox ("Move me away from the centre of the screen") > > Application.ScreenUpdating = False > For i = 1 To 100 > a = 1 > Next i > MsgBox ("done") > Application.ScreenUpdating = True > End Sub > > Regards, > Peter T > > > "JLGWhiz" <JLGWhiz(a)cfl.rr.com> wrote in message > news:%23VbmlIO0KHA.4168(a)TK2MSFTNGP02.phx.gbl... >> Hi Peter, In the version of xl03 that I am running, the msgbox goes >> away, whether or not ScreenUpdating is enabled. Is it different in xl07 >> + ? >> >> >> "Peter T" <peter_t(a)discussions> wrote in message >> news:uhrGDvM0KHA.5512(a)TK2MSFTNGP06.phx.gbl... >>> What you describe cannot and occur. I very much doubt you actually >>> tested the code you posted as an example, at least not exactly as >>> written and with nothing else. >>> >>> My guess is you are showing the msgbox with screenupdating disabled. The >>> msgbox will stay on the screen indefinitely until the screen is >>> refreshed (even DoEvents) or by re-enabling screenupdating. >>> >>> Be sure to temporarily disable screenupdating if/as necessary when >>> showing a msgbox. >>> >>> Regards, >>> Peter T >>> >>> The only thing that >>> "John Keith" <kd0gd(a)juno.com> wrote in message >>> news:o3m5r5dpb4p28chv941hjmflecglohug0i(a)4ax.com... >>>> >Is this a message box that was created with a UserForm? >>>> >>>> No >>>> >>>>> The standard message box automatically closes when a button is >>>>> clicked. If it is the >>>>>standard message box and is not closing, there could be a software >>>>>problem >>>>>in your system. Is this in Excel, if so, what version. >>>> >>>> Excel 2007/WinXP >>>> >>>> The message box window stays open until the next msgbox command is >>>> executed. >>>> >>>> I also just tried the following >>>> >>>> msgbox("Test") >>>> for i =1 to 100000000 >>>> a=1 >>>> next i >>>> msgbox("done") >>>> >>>> The loop has not completed yet and the first message box is still >>>> open. >>>> >>>> >>>> >>>> >>>> >>>> John Keith >>>> kd0gd(a)juno.com >>> >>> >> >> > >
From: JLGWhiz on 31 Mar 2010 13:11 Nope, As soon as I click the button, the shape dialog box disappears. I cannot get it to remain on screen after the button is clicked and cannot get any further code to process without clicking the button. I believe that is the designed performance. "Peter T" <peter_t(a)discussions> wrote in message news:OQswiOO0KHA.776(a)TK2MSFTNGP04.phx.gbl... > Try this > > Sub abc() > ' run with alt-F8 > Dim a > > 'Application.ScreenUpdating = False > > MsgBox ("Move me away from the centre of the screen") > > Application.ScreenUpdating = False > For i = 1 To 100 > a = 1 > Next i > MsgBox ("done") > Application.ScreenUpdating = True > End Sub > > Regards, > Peter T > > > "JLGWhiz" <JLGWhiz(a)cfl.rr.com> wrote in message > news:%23VbmlIO0KHA.4168(a)TK2MSFTNGP02.phx.gbl... >> Hi Peter, In the version of xl03 that I am running, the msgbox goes >> away, whether or not ScreenUpdating is enabled. Is it different in xl07 >> + ? >> >> >> "Peter T" <peter_t(a)discussions> wrote in message >> news:uhrGDvM0KHA.5512(a)TK2MSFTNGP06.phx.gbl... >>> What you describe cannot and occur. I very much doubt you actually >>> tested the code you posted as an example, at least not exactly as >>> written and with nothing else. >>> >>> My guess is you are showing the msgbox with screenupdating disabled. The >>> msgbox will stay on the screen indefinitely until the screen is >>> refreshed (even DoEvents) or by re-enabling screenupdating. >>> >>> Be sure to temporarily disable screenupdating if/as necessary when >>> showing a msgbox. >>> >>> Regards, >>> Peter T >>> >>> The only thing that >>> "John Keith" <kd0gd(a)juno.com> wrote in message >>> news:o3m5r5dpb4p28chv941hjmflecglohug0i(a)4ax.com... >>>> >Is this a message box that was created with a UserForm? >>>> >>>> No >>>> >>>>> The standard message box automatically closes when a button is >>>>> clicked. If it is the >>>>>standard message box and is not closing, there could be a software >>>>>problem >>>>>in your system. Is this in Excel, if so, what version. >>>> >>>> Excel 2007/WinXP >>>> >>>> The message box window stays open until the next msgbox command is >>>> executed. >>>> >>>> I also just tried the following >>>> >>>> msgbox("Test") >>>> for i =1 to 100000000 >>>> a=1 >>>> next i >>>> msgbox("done") >>>> >>>> The loop has not completed yet and the first message box is still >>>> open. >>>> >>>> >>>> >>>> >>>> >>>> John Keith >>>> kd0gd(a)juno.com >>> >>> >> >> > >
From: Peter T on 31 Mar 2010 13:32 Indeed it is normal behaviour for the code to be suspended until the msgbox is dismissed. But are you saying with screenupdating disabled the "image" of the msgbox completely disappears from the screen after clicking OK. Regards, Peter T "JLGWhiz" <JLGWhiz(a)cfl.rr.com> wrote in message news:%2365QrUP0KHA.776(a)TK2MSFTNGP04.phx.gbl... > Nope, As soon as I click the button, the shape dialog box disappears. I > cannot get it to remain on screen after the button is clicked and cannot > get any further code to process without clicking the button. I believe > that is the designed performance. > > > > "Peter T" <peter_t(a)discussions> wrote in message > news:OQswiOO0KHA.776(a)TK2MSFTNGP04.phx.gbl... >> Try this >> >> Sub abc() >> ' run with alt-F8 >> Dim a >> >> 'Application.ScreenUpdating = False >> >> MsgBox ("Move me away from the centre of the screen") >> >> Application.ScreenUpdating = False >> For i = 1 To 100 >> a = 1 >> Next i >> MsgBox ("done") >> Application.ScreenUpdating = True >> End Sub >> >> Regards, >> Peter T >> >> >> "JLGWhiz" <JLGWhiz(a)cfl.rr.com> wrote in message >> news:%23VbmlIO0KHA.4168(a)TK2MSFTNGP02.phx.gbl... >>> Hi Peter, In the version of xl03 that I am running, the msgbox goes >>> away, whether or not ScreenUpdating is enabled. Is it different in xl07 >>> + ? >>> >>> >>> "Peter T" <peter_t(a)discussions> wrote in message >>> news:uhrGDvM0KHA.5512(a)TK2MSFTNGP06.phx.gbl... >>>> What you describe cannot and occur. I very much doubt you actually >>>> tested the code you posted as an example, at least not exactly as >>>> written and with nothing else. >>>> >>>> My guess is you are showing the msgbox with screenupdating disabled. >>>> The msgbox will stay on the screen indefinitely until the screen is >>>> refreshed (even DoEvents) or by re-enabling screenupdating. >>>> >>>> Be sure to temporarily disable screenupdating if/as necessary when >>>> showing a msgbox. >>>> >>>> Regards, >>>> Peter T >>>> >>>> The only thing that >>>> "John Keith" <kd0gd(a)juno.com> wrote in message >>>> news:o3m5r5dpb4p28chv941hjmflecglohug0i(a)4ax.com... >>>>> >Is this a message box that was created with a UserForm? >>>>> >>>>> No >>>>> >>>>>> The standard message box automatically closes when a button is >>>>>> clicked. If it is the >>>>>>standard message box and is not closing, there could be a software >>>>>>problem >>>>>>in your system. Is this in Excel, if so, what version. >>>>> >>>>> Excel 2007/WinXP >>>>> >>>>> The message box window stays open until the next msgbox command is >>>>> executed. >>>>> >>>>> I also just tried the following >>>>> >>>>> msgbox("Test") >>>>> for i =1 to 100000000 >>>>> a=1 >>>>> next i >>>>> msgbox("done") >>>>> >>>>> The loop has not completed yet and the first message box is still >>>>> open. >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> John Keith >>>>> kd0gd(a)juno.com >>>> >>>> >>> >>> >> >> > >
First
|
Prev
|
Next
|
Last
Pages: 1 2 3 Prev: Getting Sheet Name from the Code Name Next: Measure on the date different |