display message while code is running
Have you tried using
Application.StatusBar = "Please wait while the list is updating."
And
Application.StatusBar = FALSE
to Turn off.
--
HTH,
Barb Reinhardt
If this post was helpful to you, please click YES below.
"Bassman62" wrote:
How can I display a message while a macro is running and then have the
message automatically stop displaying when the macro completes.
Example: "Please wait while the list is updating."
I've tried MsgBox but this seems to require a user to click on "OK".
Thank you.
Dave
|