Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1241
  • Last Modified:

Does Application.Calculation = xlAutomatic cause a calculation to be done automatically?

Hi Experts,

When the statement:

Application.Calculation = xlAutomatic

is executed, does it cause a calculation to be done when it executes?

Thanks,

taDUH
0
taduh
Asked:
taduh
  • 3
  • 2
1 Solution
 
zorvek (Kevin Jones)ConsultantCommented:
Yes.

Kevin
0
 
kgerbChief EngineerCommented:
Hi taduh,
I do not bevlieve it does.  I put a breakpoint in the worksheet code pane under the calculate event to trap the event.  Then I ran a routine which turned the calculation property to manual then back to automatic and the calculation event did not fire.  Hope this helps.

Kyle
0
 
kgerbChief EngineerCommented:
Hi kevin,
Why did my test not work then?

Kyle
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
zorvek (Kevin Jones)ConsultantCommented:
The event won't fire until you execute a DoEvents or the routine exits. Excel does not generate multiple execution threads.

Kevin
0
 
kgerbChief EngineerCommented:
Kevin,
I understand.  Thank you for the education.

Kyle
0
 
taduhFinancial Systems AnalystAuthor Commented:
Thanks, Kevin
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now