Back to: Excel Custom Function/Formulas
While I would never suggest anyone use Manual calculation in Excel, I realize that many still do. All it means is you have Spreadsheet Design issue that you SHOULD fix rather than cater to.
Function CalculationState() As String Application.Volatile Select Case Application.CalculationState Case 0: CalculationState = "Calculating" Case 1: CalculationState = "Done" Case 2: CalculationState = "Pending" End Select End Function
Function CalculationMode() As String Dim cMode As XlCalculation Application.Volatile cMode = Application.Calculation Select Case cMode Case xlCalculationAutomatic: CalculationMode = "Auto" Case xlCalculationManual: CalculationMode = "Manual" Case xlCalculationSemiautomatic: CalculationMode = "Semi-Auto" End Select End Function
Both are Volatile Functions and will recalculate when most action is used in Excel. IMPORTANT if you are in Manual Calculation neither will auto recalculate.
Excel Dashboard Reports & Excel Dashboard Charts 50% Off Become an ExcelUser Affiliate & Earn Money
Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $64.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to [email protected] 31 days after purchase date.
Instant Download and Money Back Guarantee on Most Software
Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft
Some of our more popular products are below...
Convert Excel Spreadsheets To Webpages | Trading In Excel | Construction Estimators | Finance Templates & Add-ins Bundle | Code-VBA | Smart-VBA | Print-VBA | Excel Data Manipulation & Analysis | Convert MS Office Applications To...... | Analyzer Excel | Downloader Excel | MSSQL Migration Toolkit | Monte Carlo Add-in | Excel Costing Templates