View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
EXCELMACROS EXCELMACROS is offline
external usenet poster
 
Posts: 43
Default Close msgbox automatically

Well, I did copy paste exactly what you suggested and is not closing in 5
seg...
--
Thank you...


"Mike H" wrote:

I think you need to go back and read my post again.

How about this which auto closes after 5 seconds or sooner if the user
presses OK


Mike


"EXCELMACROS" wrote:

I need to close it in 5 seg, can't wait for the user to press "ok" what do
you think?
--
Thank you...


"Mike H" wrote:

Hi,

How about this which auto closes after 5 seconds or sooner if the user
presses OK

CreateObject("WScript.Shell").popup "Your Message", 5

Mike

"EXCELMACROS" wrote:

Hello, me again.., I'm trying to close a msgbox using application.ontime now
+ 5seg

Thank you in advance
--
Thank you...