You can't have a message box without buttons - and controlling it without
user interaction is hard work.

Create a little userform and put what you want on it, when you want, and
hide and unload it when you're done.

I'm sure someone will post a link to somewhere with information about
creating a progress bar (which sounds like what you want) but I'm new here
and don't know all the links yet.

--
Enjoy,
Tony