Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Workbook_BeforeClose(Cancel As Boolean) - Cancel won't work gpmichal Setting up and Configuration of Excel 1 May 12th 09 02:33 AM
Cancel calculation big t Excel Worksheet Functions 2 June 28th 07 02:28 PM
Cancel Macro is user selects 'cancel' at save menu Mark Excel Programming 1 April 6th 05 05:45 PM
Cancel Button Matt Excel Programming 3 February 3rd 04 11:23 PM
How to Cancel a Save? Rodg2000 Excel Programming 1 January 9th 04 10:47 AM


All times are GMT +1. The time now is 12:03 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"