View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] tkt_tang@hotmail.com is offline
external usenet poster
 
Posts: 92
Default Re : Excel Worksheet_Calculate() & Worksheet_Change()

1. Enters an Excel worksheet (XL-2000).

2. Sheet1 incorporates an Autofilter (consisting of only one column
amidst several others).

3. While editing in a cell, Worksheet_Calculate() event handler would
be activated, followed suit by Worksheet_Change().

4. Have made use of Worksheet_Calculate() to handle Autofilter
tabulation events.

5. In this case, activation of Worksheet_Calculate() has indeed
interfered with the user operations.

6. It would have been more desirable to activate Worksheet_Change()
prior to Worksheet_Calculate().

7. Is there an alternative to sequence the activation of
Worksheet_Change() followed suit by Worksheet_Calculate() ?

8. Please share your experience.

9. Regards.