| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Message telling calculation is complete
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Message telling calculation is complete
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Message telling calculation is complete
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Message telling calculation is complete
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Message telling calculation is complete
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Message telling calculation is complete
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I get a file in use message telling me that the file is locked ? | New Users to Excel | |||
| formula telling me if person is 19 or older today | Excel Discussion (Misc queries) | |||
| how come microsoft wont let me type? it's telling me is locked | Excel Discussion (Misc queries) | |||
| Are you kidding me??? Are you telling me I can't sort format: dddd, mmmm dd, yyyy? | Excel Discussion (Misc queries) | |||
| Telling the difference between zero and blank in IF statement | Excel Worksheet Functions | |||
Hybrid Mode
