Ken,

In VBA, go to the Tools menu, choose References, then choose
"Windows Script Host Object Model". Then, use code like the
following:

Dim WSH As IWshRuntimeLibrary.WshShell
Dim Res As Long
Set WSH = New IWshRuntimeLibrary.WshShell
Res = WSH.Popup(Text:="Your Text", secondstowait:=5, _
Title:="Title", Type:=vbYesNo)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Ken Loomis" wrote in message
...
I run a routine that can take quite some time. I'd like to
present a MsgBox at various stages of this operation, in case
the user is sitting there watching.

But, I'd like the message box to go away on it's own to let the
process continue even if the user isn't there to answer.

For example, when all the files that need to be processed have
been found, I'd like a message box to appear that says
something like:

"22 files that need to be processed have been found. Click OK
to continue processing these files. Or, just wait for this
message to disappear."

This way the user can start the process and go to lunch or
whatever and it will still complete.

TIA,
Ken