MsgBox taking a long time to clear from screen

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sjharri@gmail.com - 20 Sep 2006 09:56 GMT

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

Reply to this Message

Bob Phillips - 20 Sep 2006 11:27 GMT

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

Signature

HTH

Bob Phillips

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

> 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
[quoted text clipped - 4 lines]
> Thanks
> Steve

Reply to this Message

semiopen@hotmail.com - 20 Sep 2006 13:56 GMT

> 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
[quoted text clipped - 4 lines]
> Thanks
> Steve

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

HTH

-semiopen

Reply to this Message