Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations waross on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel calculation mode - VBA concise and verbose statements

Status
Not open for further replies.

TomBarsh

Structural
Jun 20, 2002
1,003
CA
I recently was befuddled with some VBA code and had to sort things out.

The statement to change the application's calculation mode is:
Application.Calculation = [something]

I've always used (well, for 20 years or more?) the "somethings" as:
= xlCalculationAutomatic
= xlCalculationManual
= xlCalculationSemiautomatic

Call these the verbose formats. I now realize there are the concise formats:
= xlAutomatic
= xlManual
= xlSemiautomatic

I've even found that I used the concise formats myself in some very old Excel files. I guess I forgot about them after using my reference books that use the verbose format.

I have tested and they do the same things and are equivalent. When I recorded a macro while assigning the calculation mode Excel VBA used the concise format. When I assign the calculation mode in code using the verbose format then have a msgbox report on the calculation mode it also uses the concise format...thus I have to assume the concise and verbose are equivalent.

I found on-line references use either but do not talk to the fact that there are both and they are equivalent. Here are two references from random sites:

uses the concise format

O'Reilly uses the verbose format

Anyway, I suppose this is more of a PSA rather than a question or a rant. It's something that I was surprised to see and realize after so many years of using VBA.

Excel. A great and wonderful tool! Sometimes mysterious and frustrating.
 
forum766 maybe?

Skip,
[sub]
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue][/sub]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Top