Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Worksheet_Calculate or Worksheet_Change? | Excel Programming | |||
Nesting worksheet_Calculate inside worksheet_CHANGE | Excel Programming | |||
worksheet_change vs. calculate, and worksheet_change not running | Excel Programming | |||
worksheet_change vs. calculate, and worksheet_change not running | Excel Programming |