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

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

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