MsgBox timer working only once

[wawamr2]

Hello All

I have a code that search a different name in a database one after the other. I know the some name wont be found. So I have a error popup message saying it's not found. I have put a timer so the message close after 1 sec. It work for the first error, but not for the subsequant error message. It close only when I click OK. Error code at the end of the macro in green. What do you suggest?

Please Login or Register  to view this content.

[LJMetzger]

Hi wawamr2,

Instead of using a VBS MsgBox, you might want to consider using a UserForm which simulates a MsgBox such as in Sub TestOne below. See the file associated with post #4 in the following link which contains the code below: http://www.excelforum.com/excel-prog...ond-timer.html

Ordinary Code module Test code:

Please Login or Register  to view this content.

UserForm UserFormMsgBox code:

Please Login or Register  to view this content.

Ordinary Code Module ModUserFormMsgBox code:

Please Login or Register  to view this content.

I hope this helps.

Lewis