Share via

VBA MessageBox with embedded countdown

Anonymous
2022-08-29T16:55:06+00:00

Dear all,

by this VBA code

CreateObject("WScript.Shell").PopUp "Test Message", 10, "Test Title", vbOKOnly

the message box gets closed after 10 seconds or If the button "OK" gets pressed.

It works good but I would also like to have an active countdown in the Userform behind the message box as indicated by the red arrow (So it should be something like 00:08...00:07...00:06...00:05 and so on)

Is it possible to do it?

Thanks

Microsoft 365 and Office | Excel | Other | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-08-29T22:54:44+00:00

    Hi there

    Please, Check this video. It will help you to create the macro

    https://youtu.be/sbJeGG_Xv8M

    Regards

    0 comments
  2. Anonymous
    2022-08-30T15:58:58+00:00

    Hi there

    Please, Check this video. It will help you to create the macro

    https://youtu.be/sbJeGG_Xv8M

    Regards

    This is good but I also need to keep the MessageBox while the countdown goes...

    0 comments