Forum Discussion

Michael1835's avatar
Michael1835
Copper Contributor
Nov 18, 2024

VBA code - Calculate Formula from dropdown

Hi, I have a workbook where I have had to disable automatic calculations due to workbook being slow.  Could somebody advise a code to calculate formulas whenever an item is selected in a dropdown? ...
Excel
Formulas and Functions
Macros and VBA
  • HansVogelaar's avatar
    HansVogelaar
    Nov 18, 2024

    Above the End Sub line of CheckTrainingStatus:

        Me.Calculate

    or if you only want to recalculate columns AR to AT:

        Me.Range("AR:AT").Calculate

HansVogelaar's avatar
HansVogelaar
MVP
Nov 18, 2024

Above the End Sub line of CheckTrainingStatus:

    Me.Calculate

or if you only want to recalculate columns AR to AT:

    Me.Range("AR:AT").Calculate

Resources