EXCEL VBA Questions and Answers

What are keyboard shortcuts and their equivalent VBA methods for Formulae calculation and building Excel dependency trees?

Shortcut Combination VBA Equivalent Meaning
F9 Application.Calculate Recalculate
Ctrl+Alt+F9 Application.CalculateFull Full Calculation
Ctrl+Alt+Shift+F9 Application.CalculateFullRebuild Rebuild Excel Dependency Tree and Full Calculation
Shift+F9 Sheets(1).Calculate calculate Worksheet