Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to cancel a calculation in VBA
Does anyone know how to cancel an Excel calculation sequence part-way
through, within a UDF? I want to do the following: 1) Excel calculates a workbook that has several UDF calls that each take a long time. 2) The user can cancel a call using a Cancel button on a pop-up window. This I am doing OK already. 3) This should then cancel the sequence (as if they have pressed Escape), so they don't have to press Cancel for each call that Excel makes to each UDF. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Workbook_BeforeClose(Cancel As Boolean) - Cancel won't work | Setting up and Configuration of Excel | |||
Cancel calculation | Excel Worksheet Functions | |||
Cancel Macro is user selects 'cancel' at save menu | Excel Programming | |||
Cancel Button | Excel Programming | |||
How to Cancel a Save? | Excel Programming |