Thread: MsgBox question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ken Loomis Ken Loomis is offline
external usenet poster
 
Posts: 143
Default MsgBox question

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