Prev: VBA Find a Replace
Next: Programming MS Word into .NET Website
From: data.file on 10 Jan 2010 14:03
For a longish macro (made up of a few smaller macros), what is a simple way
of displaying a message box saying "operation in progress, etc", and then
when the macro has finished, another message box with an OK button saying
"operation completed"?


From: data.file on 10 Jan 2010 18:35
"Gordon Bentley-Mix" <gordon(a)NOSPAM.exmvps.org> wrote in message
news:eCahDDkkKHA.1652(a)TK2MSFTNGP05.phx.gbl...
> For the first requirement, just create a UserForm with the appropriate
>...

Thanks.

I somehow thought that both of the messages would be as simple as the second
one. And even though this macro is for my personal use, I implemented your
suggestions and it works.

Regards,

Sergey



From: data.file on 10 Jan 2010 19:35

"Gordon Bentley-Mix" <gordon(a)NOSPAM.exmvps.org> wrote in message
news:ugBaLUlkKHA.6096(a)TK2MSFTNGP02.phx.gbl...
> Unfortunately, Word VBA doesn't provide a "buttonless" non-modal message
> box that can be invoked and dismissed programmatically. Any message boxes
> you display using the MsgBox function will always be modal (which will
> halt code execution) and always require user intervention to dismiss
> (which means at least one button and an associated user action). The only
> choice you have is to build your own. Glad my method appears to be working
> for you.
> --
> Cheers!

Your method works, not appears to be working.

Cheers,

Sergey


 | 
Pages: 1
Prev: VBA Find a Replace
Next: Programming MS Word into .NET Website