There are a number of possibilities:
  • Create a userform with your message on it, show it before running and then unload it at the end.
  • Display a "Done" message at the end using the inbuilt MsgBox function
  • Change the cursor to an egg-timer while the code is running
  • Use DoEvents periodically to refresh the screen and update the statusbar with the progress.