You want something like a modeless userform that updates itself. For
example:

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

For a simple solution, just use the status bar. It's at the bottom of
the Excel window where it usually says "Ready" at the bottom. For
example

Application.Statusbar = "Running macro now..."

And when it's done:

Application.Statusbar = False

HTH,
JP

On Mar 20, 12:35*pm, K wrote:

I have macro which is set on a button in a spreadsheet and few other
colleagues use that spreadsheet as well. *The macro basically get data
from other sheet and update the current sheet. *I want macro to put
before the present macro so when someone hit the button the message
should come up saying "PLEASE WAITE......." and the dots after word
"PLESE WAITE" should increase and decrease, as happens when you
install some software then my present macro should run and after when
the present macro finish updating the spreadsheet the message should
come up saying "UPDATED". please explain brefly how this can be done.
Many Thanks- Hide quoted text -

- Show quoted text -