ajliaks


Hi guys,

I need to prompt a mesage box telling "XYZ" and automatically close it after 3 minutes.

Thanks in advance for any help.

Aldo.





Re: Vba Excel 2003 - Prompt Message Box with timer

MyLady


Hey,

I think you have to create your own message box with a label on it.

In the userform code module put the following code and the userform (message box) will stay displayed for just three seconds and then automatically disappear.

Private Sub UserForm_Activate()

Application.Wait Now + TimeValue("00:00:03")

Unload Me

End Sub

Best Regards

Cathrine






Re: Vba Excel 2003 - Prompt Message Box with timer

ajliaks

Thanks!