search

cristianbuse / VBA-FastExcelUDFs

Excel User Defined Functions (VBA) run faster
MIT License
14 stars 4 forks source link

Why xlAnyKey? #2

Closed Greedquest closed 1 year ago

Greedquest commented 1 year ago

Could you not allow the default Esc Key - i.e. just make sure it's not xlNoKey?

Notes

  • The Fast Calculation is only triggered if a Calculation Interruption is possible. For that make sure:
  • Application.CalculationInterruptKey = xlAnyKey
  • Application.CalculationInterruptKey <> xlNoKey
cristianbuse commented 1 year ago

Hi @Greedquest ,

If Application.CalculationInterruptKey is set to xlEscKey then the 'fake' mouse input being sent in the InterruptCalculation method does not stop the calculation.

I tried sending an Esc key input a few years ago but never got it to work properly and so I went with the mouse input. I should probably try again as I posses more knowledge now than back then but for now your suggestion does not work with the current mouse approach.

Thanks!