MsgBox taking a long time to clear from screen
 

I have a spreadsheet with a MsgBox and an Ok button that takes a long
time to clear off the screen after the Ok button has been selected. In
fact another MsgBox appears over it. Is there anyway I can control the
speed with which the msgbox clears from the screen after the Ok button
has been pressed?

Thanks
Steve

MsgBox taking a long time to clear from screen
 

Perhaps something else is happening. Can you post all your code?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

wrote in message
ps.com...
I have a spreadsheet with a MsgBox and an Ok button that takes a long
time to clear off the screen after the Ok button has been selected. In
fact another MsgBox appears over it. Is there anyway I can control the
speed with which the msgbox clears from the screen after the Ok button
has been pressed?

Thanks
Steve

MsgBox taking a long time to clear from screen
 

wrote:
I have a spreadsheet with a MsgBox and an Ok button that takes a long
time to clear off the screen after the Ok button has been selected. In
fact another MsgBox appears over it. Is there anyway I can control the
speed with which the msgbox clears from the screen after the Ok button
has been pressed?

Thanks
Steve

Maybe try a DoEvents right after the message box that isn't vanishing
when it should.

HTH

-semiopen