Calling Macro based on cell change

[Ferloft]

Hello, I am currently using this code to call a macro whenever one of the key cells changes

Please Login or Register  to view this content.

I have it set up so that when Macro1 is finished, the cell directly below the changed cell will be selected. This is what would happen naturally if a user was to type in a value and press Enter. Another way Macro1 can be triggered is if a user typed in a value and then clicked in any other cell. The way this is set up however regardless of where they click it will always go to the cell below the one they typed in.

I am wondering if there is any way to have the cell they clicked on be the selected cell, as it would make the effects of the macro less apparent.

If I need to clarify something please feel free to ask.

Thanks!

[ragulduy]

Please Login or Register  to view this content.

[Ferloft]

Changed to this

Please Login or Register  to view this content.

Works perfectly, thanks yudlugar