Make a nominated cell turn RED during calculation period and GREEN when all
complete.
My calculation is very large with alot of "IF" fuctions takes 20+ seconds.

Check out this page, see the CalculationStatus function - should be able to
modify that or use as is to accomplish your task.
http://www.ozgrid.com/VBA/calculation-mode-status.htm

If you need more help with that, just post back.



"Ross in Oz" wrote:

Make a nominated cell turn RED during calculation period and GREEN when all
complete.
My calculation is very large with alot of "IF" fuctions takes 20+ seconds.

I tried this with little success.
I have set Options to "Auto" calculate and I think this Fuction is for
"Manual" only
Ross

"JLatham" wrote:

Check out this page, see the CalculationStatus function - should be able to
modify that or use as is to accomplish your task.
http://www.ozgrid.com/VBA/calculation-mode-status.htm

If you need more help with that, just post back.



"Ross in Oz" wrote:

Make a nominated cell turn RED during calculation period and GREEN when all
complete.
My calculation is very large with alot of "IF" fuctions takes 20+ seconds.

You could be right, I may have misinterpreted the last paragraph below both
sets of code to mean that neither would work in Manual calculate mode, but
looking at the first paragraph above the code, it hints that it works in
Manual mode.

I'll keep nosing around - but while you can detect when either the workbook
or a worksheet BEGINS calculation, there's not a ready way to find out when
it quits in automatic mode.

"Ross in Oz" wrote:

I tried this with little success.
I have set Options to "Auto" calculate and I think this Fuction is for
"Manual" only
Ross

"JLatham" wrote:

Check out this page, see the CalculationStatus function - should be able to
modify that or use as is to accomplish your task.
http://www.ozgrid.com/VBA/calculation-mode-status.htm

If you need more help with that, just post back.



"Ross in Oz" wrote:

Make a nominated cell turn RED during calculation period and GREEN when all
complete.
My calculation is very large with alot of "IF" fuctions takes 20+ seconds.

Did you find anything nosing around?
Ross

"JLatham" wrote:

You could be right, I may have misinterpreted the last paragraph below both
sets of code to mean that neither would work in Manual calculate mode, but
looking at the first paragraph above the code, it hints that it works in
Manual mode.

I'll keep nosing around - but while you can detect when either the workbook
or a worksheet BEGINS calculation, there's not a ready way to find out when
it quits in automatic mode.

"Ross in Oz" wrote:

I tried this with little success.
I have set Options to "Auto" calculate and I think this Fuction is for
"Manual" only
Ross

"JLatham" wrote:

Check out this page, see the CalculationStatus function - should be able to
modify that or use as is to accomplish your task.
http://www.ozgrid.com/VBA/calculation-mode-status.htm

If you need more help with that, just post back.



"Ross in Oz" wrote:

Make a nominated cell turn RED during calculation period and GREEN when all
complete.
My calculation is very large with alot of "IF" fuctions takes 20+ seconds.

Sorry, not yet. Still looking.

"Ross in Oz" wrote:

Did you find anything nosing around?
Ross

"JLatham" wrote:

You could be right, I may have misinterpreted the last paragraph below both
sets of code to mean that neither would work in Manual calculate mode, but
looking at the first paragraph above the code, it hints that it works in
Manual mode.

I'll keep nosing around - but while you can detect when either the workbook
or a worksheet BEGINS calculation, there's not a ready way to find out when
it quits in automatic mode.

"Ross in Oz" wrote:

I tried this with little success.
I have set Options to "Auto" calculate and I think this Fuction is for
"Manual" only
Ross

"JLatham" wrote:

Check out this page, see the CalculationStatus function - should be able to
modify that or use as is to accomplish your task.
http://www.ozgrid.com/VBA/calculation-mode-status.htm

If you need more help with that, just post back.



"Ross in Oz" wrote:

Make a nominated cell turn RED during calculation period and GREEN when all
complete.
My calculation is very large with alot of "IF" fuctions takes 20+ seconds.