Is there a way to display the status of a long-running piece of code, other
than on the status bar with Application.StatusBar?

What I want is one of those nice nonmodal forms in the middle of the screen
that keeps changing the message. Problem is, when I try to do this with a
regular form, and I execute frmName.Show, the code freezes -- as if it was a
MsgBox.

Anyway to display a form, but keep the code running?

Thanks.

ExcelMan,

Check out this information from John Walkenbach.

http://www.j-walk.com/ss/excel/tips/tip34.htm

He shows you how to build a progress indicator.

Best regards,
Kevin

"ExcelMan" wrote in message
...
Is there a way to display the status of a long-running piece of code,
other
than on the status bar with Application.StatusBar?

What I want is one of those nice nonmodal forms in the middle of the
screen
that keeps changing the message. Problem is, when I try to do this with a
regular form, and I execute frmName.Show, the code freezes -- as if it was
a
MsgBox.

Anyway to display a form, but keep the code running?

Thanks.