MsgBox automatically closes after x seconds.

  • Best you're going to be able to do, I believe. Is to create your own userform so that you can display it then have an application.ontime routine that you can close and identified form.


    I have something very similar in all of my projects. Many of my projects require that they run to process external data, however, when I need to work in them I need to be able to stop this auto update ability. So I made a userform that displays on open and will time out in 30s and begin the auto update.

    It also has a button that allows me to actively cancel the auto update. I'll attach the modules ... you should just be able to import them ... read them ..... modify at will.CodeModules.zip