Custom action needed for messagebox in VBA

[selvamariappan]

I have some code that runs with a number of calculations,
Intially I pop up a message box to the user to proceed.If they click "Ok" or "yes".Then i need to display a message box without any button stating that " Please wait "

Is there a way to automatically display the Msgbox and continue with the code execution and after a code moves to display the msgbox as "Successfully submitted".

Or is there a way to post a dialog box or msgbox without any "OK" button, that will just appear but not halt my code.

Thank you very much for any and all help.

 

[RoryA]

Create a userform, add a label with whatever caption you want, then show it modelessly at the start of the code using:

userform1.show false

for example.

 

[selvamariappan]

Once again I got reply from you rorya, Thanks for your update.

Intially I have used the code as below.

userform1.show

so the user form shown and the background process, running continously and its not hided.Then your code helps me,

"userform1.show False"

What is the use of that False.

Thanks,
Selva.C

 

[RoryA]

False loads the form modelessly so that the calling code then simply carries on running.