Close msgbox automatically
This method worked, thank you MIKE ; LEITH ; ORION and PETER
--
Thank you...
"Peter T" wrote:
The WScript.Shell - popup method is not reliable to dismiss a msgbox. It may
work in some machines, not at all, or erratically (does not seem to relate
to windows version).
Best way is make a userform to look like a msgbox, perhaps pass a message to
a label caption and include some sort of timer to dismiss the form if still
showing after say 5 seconds, eg
' userform code
Private mbShow As Boolean
Private Sub UserForm_Activate()
Dim t As Single
Dim ShowTime As Single
mbShow = True
ShowTime = 5
t = Timer
While (Timer < ShowTime + t) And mbShow
DoEvents
Wend
If mbShow Then
Unload Me
End If
End Sub
Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
mbShow = False
End Sub
Regards,
Peter T
"EXCELMACROS" wrote in message
...
Hello, me again.., I'm trying to close a msgbox using application.ontime
now
+ 5seg
Thank you in advance
--
Thank you...
|