Time Out a MsgBox
Hi,
How about this instead which closes after 5 seconds or when OK is pressed
CreateObject("WScript.Shell").Popup "Some message", 5, "Your Title"
--
Mike
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
"JT1977" wrote:
I have a file that runs a macro when it is open. This file may be opened
manually or automatically by a macro from another file.
If the file is opened manually I would like a MsgBox to prompt the user to
end the macro before it gets into the body of the code.
If the file is opened automatically I would like the MsgBox to automatically
respond after a time delay to allow the macro to continue running the bulk of
the code.
Is there anyway to force a response to a MsgBox after a preset amount of
time with no response from the user?
|