I have a macro that takes quite a while to complete - is there anything I can
have displayed to the user that will say "please wait" or show a progess bar
or something?

thanks

There are plenty of progress bars out there. Here is a good one
http://www.enhanceddatasystems*.com/...ogressBar*.htm


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ciara" wrote in message
...
I have a macro that takes quite a while to complete - is there anything I
can
have displayed to the user that will say "please wait" or show a progess
bar
or something?

thanks

That link gave me this - is this my fault?

Bad Gateway
The following error occurred:
[code=DNS_HOST_NOT_FOUND] The host name was not found during the DNS lookup.
Contact your system administrator if the problem is not found by retrying the
URL.


--------------------------------------------------------------------------------
Please contact the administrator.

"Bob Phillips" wrote:

There are plenty of progress bars out there. Here is a good one
http://www.enhanceddatasystemsÂ*.com/ED/Pages/ExcelProgressBarÂ*.htm


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ciara" wrote in message
...
I have a macro that takes quite a while to complete - is there anything I
can
have displayed to the user that will say "please wait" or show a progess
bar
or something?

thanks

Try this, it looks the same but hasn't got spurious - in it that Google
inserts

http://www.enhanceddatasystems.com/E...rogressBar.htm

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ciara" wrote in message
...
That link gave me this - is this my fault?

Bad Gateway
The following error occurred:
[code=DNS_HOST_NOT_FOUND] The host name was not found during the DNS
lookup.
Contact your system administrator if the problem is not found by retrying
the
URL.


--------------------------------------------------------------------------
------
Please contact the administrator.

"Bob Phillips" wrote:

There are plenty of progress bars out there. Here is a good one
http://www.enhanceddatasystems*.com/ED/Pages/ExcelProgressBar*.htm


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ciara" wrote in message
...
I have a macro that takes quite a while to complete - is there
anything I
can
have displayed to the user that will say "please wait" or show a
progess
bar
or something?

thanks

If you macro is performing a bunch of sequential actions, then you can show
a progress bar and have you code update it. (progress bars don't update
themselves). If you issue one command and it takes a long time, then a
progress bar would be useless. You can make a worksheet visible that has a
message of Please Wait.

See John Walkenbach's site for a simple example:

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

--
Regards,
Tom Ogilvy


"Ciara" wrote in message
...
I have a macro that takes quite a while to complete - is there anything I
can
have displayed to the user that will say "please wait" or show a progess
bar
or something?

thanks