Sorry to keep going here...but I did copy the userform and module into my
workbook. But what do I need to do to get the progress bar to appear during
a calculation. Thanks again.

"Gord Dibben" wrote:

You would have to download the workbook from Andy's site then copy the userform
and code module to your workbook..

I would recommend moving the UserForm1 and Module1 to your Personal.xls so you
have access to all the types of meters for all open workbooks

To access the form and module, open Andy's workbook then Alt + F11 to get to the
Visual Basic Editor.


Gord


On Tue, 29 Apr 2008 07:25:03 -0700, deeds
wrote:

Thanks...these look great...however, can you tell me how I actually add one
of these progress meters to my file? Thanks.

"Gord Dibben" wrote:

See Andy Pope's site for a workbook with various progess bars.

http://www.andypope.info/vba/pmeter.htm


Gord Dibben MS Excel MVP

On Mon, 28 Apr 2008 06:41:03 -0700, deeds
wrote:

Thanks...however, that area of the screen is being taken up by another
application. So, I cannot see the calculation meter. Is there some quick
little messge box I can create or a cell I can put code to tell user when
calc is complete? Thanks.

"jlclyde" wrote:

On Apr 25, 10:04 am, deeds wrote:
I am looking for something that would tell end user that the calculation
process is complete. Something simple like text in a cell that appears when
calc is complete. Any ideas? Thanks Much!

In the bottom left hand corner of the screen there is a calculate.
When it is calcualting it says so it also says what % it is at.

Jay