Solved: how to have "Screen message pop up" before background finished processing ?

[beginner]

hello all....

would like to seek some help here about any method to initiate an "on-screen message" when the VBA's is doing something for over 10 minutes...., then that "on-screen message" close automatically when the VBA processing finished......Thanks a lot.

Not sure if msgbox can achieve this or not, but i got question mark on using msgbox:-

- msgbox need to click the "confirmed" button in order to continue the process, however, i need to have the message pop up only (without need to click button to start the process) and close when the process finished.


Thanks in advance for any helpers.....

beginner

[Cosmos75]

You can ;

• create a form with a message in a label
• use VBA to open it when the code starts
• and then to close close it when the code ends or when it exits dur to error handling.

If you want to stop the user from closing it or doing anything else, set it to have a dialog border with no close button and set the pop-up/modal property to true.

[beginner]

hi Cosmos75, tks for your tips and i believed this could solved my problem. tks!

[beginner]

hello....my problem seems not 100% gone away, not sure how to make that "message" Form created to be stayed all the time on top of all others background screens which is refreshing on and off ?? tks for any tips....

BR/

[xCav8r]

Tried setting modal = true?

[beginner]

hi xCav8r, tks for your help again.! the problem is solved.

[xCav8r]

Glad to help!