I saw some discussion on this the other day and one simple method was to
create a message on a separate sheet (one not used in your main program) and
put that sheet on screen until the code reaches a certain point, then put the
appropriate worksheet back on screen. See the example:

Sub x()
'Start program
'Change to screen with message telling user that processing continues
'run the main body of code
'Chane to screen showing results of processing
'Close program
End Sub

I have not tried it, but it seems simple enough.

"Claus Højlund" wrote:

Is it possible to have a MsgBox without OK or cancel, simply telling what is
going on? I want to use it with a macro that takes a while, so for the user
it would be nice to know that everything is ok and the machine is working
hard and so on. I can't find such a VBA command. Can anyone help?