Worksheet_change event (not working to execute filter)

[Rudo123]

Hello guys.

Would you please help me with one thing ? My goal is to run macro based on Worksheet_change event. My target cell is being updated based on hyperlink function.
So at first, I have this function >>

Please Login or Register  to view this content.

I thought, that when G2 cell is updated (based on selection), then I can use Worksheet_change event, but it seems this is not possible. Here is my code which doesn't work as intended >>

Please Login or Register  to view this content.

If I click on G2 and manually change content, it works, but when I use hyperlink function to update G2, it doesn't work.
Please, do you know if I can somehow get around this ?? I would like to use Hyperlink method, is it looks pretty professional and elegant.

I use MSO 2010.

thanks a lot.

[xladept]

Maybe if you change the Function to a Sub

[Rudo123]

Ho xladept.
I doubt this will help:-( Purpose of using Function is that I need to have some outcome (value).
Please, see below file. Purpose fo Hyperlink function is that user will just put his mouse over arrows (2. tab, line 2) and cell G2 will be automatically updated.
Thus I suppose I need to use Function and not Sub.

But despite G2 cell has different content, it doesn't trigger event, and thus macro. Only when I click on G2 and manually change it to something else, event/macro is executed.

[xladept]

Well, your code is Function in name only (FINO?) that's why I suggested Sub and you can't expect a function to actually do anything.

Please Login or Register  to view this content.

* I think that's what it would look like as a function

[Rudo123]

But result is the same. Purpose of function either the way I wrote or what you wrote is the same....to update cell G2 (in second tab), when user put mouse over cells B2:F2.
So when mouse is put over cell B2, then B1 value ("BA") is put as G2 value. Regardless if your method or my method is used, result is the same.

but problem is that this type of update of G2 cell doesn't trigger macro/worksheet_change event. I read somwhere, but don't remember where, that this type of cell update (using hyperlink method) doesn't trigger event. Why I posted this question here is, that it's seems to me strange...

[xladept]

This triggered:

Please Login or Register  to view this content.

[Rudo123]

That's right, but please, is possible to avoid creation of another Procedure (above it's TestFun() ) ?
Because Function above already updates G2 cell....why this update isn't sufficient to trigger event ?
This function is called by functions placed in cells B2 : F2. Beauty of this solution would be that user doesn't need to run any macro explicitely.

I understand that Function by itself doesn't do anything. My type of solution is to call this function by standard functions written normally in cells B2:F2. Your solution is to call function by another procedure. I am just curious why my way of calling Function doesn't trigger event and your way of solution yes....if in both ways cell G2 is updated.

But still thanks a lot for help ! I will not tackle this more and will take it as it is:-)