Closing a Message Box Automatically

Frequently when writing my macros, I want a message box to come up, but if nobody clicks OK after 2 seconds I want the message box to close and the macro to continue to run. I don't know the proper code, but here is my attempt.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

This code doesn't close the message box or continue running the code that comes afterward until you click "OK".

Hi, should be something like this:

Please Login or Register  to view this content.

If you are happy with the code to run without response from OP why have it?

juls

Nu2Java, this doesn't run the rest of the code until you click "OK".

julhs, my coworker and I write messages to each other to keep each other up to date. It's not essential that we read them and if we go to the bathroom or something I don't want the macro to waste all that time.

Do you have a better idea, without making a new sheet or writing in the actual workbook?

I am wondering how you are using the code because this works for me and closes automatic and continues running the rest of the code after.

I do notice on a slower PC that you must give it atleast 3 seconds, otherwise it might not close.

It is just that I have written messages in to my code and have been wondering if all of them are necassary so curious as to your reason for keeping yours

What's the rest of your code???