dynamic msgbox?

[anny]

Greetings XLers

I have code which takes several seconds to run, during which time the screen
is not updated. How can I use a msgbox to say "Please wait ...", with no
buttons, but with dots 'marching' to the right. (say once every second)

much thanks Anny

[MattShoreson]

check this...

http://www.cpearson.com/excel/Progress.htm