Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi.
I have some code which I would like to have run each time that the selection criteria are changed in an auto- filtered table. The code itself is working fine, but the trigger is not. I tied it to the sheet's code, and asked it to run with the Worksheet_Change event... but it's not triggering unless I actually go in and change a value. I had had it tied to the Worksheet_SelectionChange . It didn't trigger then either... unless I went in and changed cells. That made some sense, which is why I changed it to the worksheet_change event. Changing the criteria in an auto-filter isn't seen as a worksheet_change? Does anyone have a suggestion as to how to trigger the code this way, or a better way? Thanks. Mark |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Disabling WORKSHEET_CHANGE event | Excel Discussion (Misc queries) | |||
Worksheet_Change event question | Excel Programming | |||
xl97 and Worksheet_Change event ? | Excel Programming | |||
Triggering click event of a menu in vba | Excel Programming | |||
Triggering click event of a menu in vba | Excel Programming |