Popup window to confirm script is complete

Hi guys,

I have a full script that send a automated email when run,

So far, it's perfect. But i would like that, once the script is completed i get a "completed" popup in excel, and then user can press "ok", and thats it.

I know it is not complicated, but i have yet to find a script like this one.

Thanks!

Just add a message box right before the end sub at the very end.

Sub whatever()
'your full script
Msgbox("Completed")
End Sub