(Msg. 1) Posted: Wed Jul 08, 2009 4:28 am
Post subject: advise calculation is complete Archived from groups: microsoft>public>excel>misc (more info?)
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.
(Msg. 2) Posted: Wed Jul 08, 2009 8:46 am
Post subject: RE: advise calculation is complete [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
> 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.
(Msg. 3) Posted: Wed Jul 08, 2009 7:49 pm
Post subject: RE: advise calculation is complete [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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.
(Msg. 4) Posted: Wed Jul 08, 2009 9:02 pm
Post subject: RE: advise calculation is complete [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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.
(Msg. 5) Posted: Mon Jul 13, 2009 3:06 am
Post subject: RE: advise calculation is complete [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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.
(Msg. 6) Posted: Mon Jul 13, 2009 10:39 pm
Post subject: RE: advise calculation is complete [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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.
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office