Hello !

I'm modifying an application written in Excel 2003 VBA.

After an operation ends, I'd like to display a confirmation message in
a window that will close itself after a given period of time (2
seconds).

This way, the user will get the feedback whithout having to click on a
MsgBox like "Ok" button.

I succesfully programmed a modeless form which will correctly do this
when used alone.

The problem is that in the application, this form is invoked from
another form which is modal. Upon displaying the confirmation message,
I get an error message saying that a non-modal window can't be open
while a modal window is open.

While making the calling modal form "modeless" may solve the problem in
that specific case, this worries me a little because this way, the user
can access the spreadsheet behind while the form is open and this is
not desired.

Searching on the net, I also found a code sample that uses the windows
api to simulate a "timer" object on a form, but was unsuccessful to
make it work.

Do anybody knows if this can be done, and if so, how ?

Thanks !