Display Message Box for 5 seconds

[robertguy]

Hi,

can anyone please advise of the VBA code to display a message box i.e. ' Working On It.....' and close automatically after 3 seconds i.e with out any input from the user


Any assistance received would be greatly appreciated

Many thanks in advance

Regards

Rob

[ImranBhatti]

As for as I know , it is not possible to scheduled a msgbox. You may use a custom user form instead and unload it for what ever time gap you want.

[rorya]

Someone will probably advise the Shell.Popup method. I'll just warn you now that it is notoriously unreliable. A userform is a better bet, or an API call: https://www.excelforum.com/excel-pro...rm-msgbox.html

[robertguy]

For clarification,

my code runs and takes a long time and what I want is a message box to pop up at key points in the code and says 'Working On It.....' and close automatically after 3 seconds

[ImranBhatti]

No problem at all. you can add .show at any point and unload it with Application.wait method.

[rorya]

It sounds like you'd be better off with a progress bar to me.