Is there a way to trigger active cell change event within a *remained* range selection?

[MeiR_ct]

Hello.

I wonder how can I trigger a code when the active cell is changed inside a selected range, like when pressing the tab key.
The "Worksheet_SelectionChange" event fires only when the whole selection is changed.

I especially need this when using the find dialog:
When I select a whole column and search inside it, I want the code to insert a comment with information to the active cell, whenever I press "Find Next".
the problem is that the whole column remains selected, and only the active cell changes and get highlighted with every pressing on "Find Next", therefore "Worksheet_SelectionChange" doesn't fire up.

I'm using Excel 2007.

Thanks in advance,
Meir

 

[MeiR_ct]

Bump.

Please tell me if I didn't explain my issue properly.

 

[MeiR_ct]

Anyone?

 

[MeiR_ct]

(Cross-posted in ExcelForum)