Hi NG.

I have a litte problem with my Macro. I would like to show a message-box
with vbyesno-buttons. This msgbox should stay open for about 5-10sec and
then close automatically.
In the msgbox I ask the user if he wants to open an Excel-file, and he can
answer "yes" or "no", as expected :)
But at the msgbox the macro stops and waits until the user clicks a button.
Now I don't want the macro to wait for eternity and go on after the
specified time. If the user didn't click a button in this time the
msgbox-result should be set to "yes" and the box should close.
I think an application.wait is not the right way, because excel waits before
the msg is shown or the msg appears before the wait command is active.
Or do I have to create a UserForm?

Has anyone an idea how to solve this?

Thanks in advance.

MB