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

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!